Many thanks for taking the time to provide such valuable information. On Wed, Sep 28, 2022 at 9:53 AM Ashish Vijaywargiya < [email protected]> wrote:
> Hello Emad, > > We have many Accounting experts in the Apache OFBiz community and I have > learned many things from them. They are: > - Jacopo - https://www.linkedin.com/in/jacopoc/ > - Anil - https://www.linkedin.com/in/anilpatelhwc/ > - Sharan - https://www.linkedin.com/in/sfoga/ > > They have helped to build the Accounting module from scratch in Apache > OFBiz and now we can see a finished component. > They referred a few books while implementing and enhancing the Accounting > module(See Index of these books): > > Universal Data Model Volume 1 by Len Silverstone - All the chapters are > important one but Chapter 7 and 8 will make more sense to get a good > understanding of Accounting. > > https://www.amazon.com/Data-Model-Resource-Book-Vol/dp/0471380237/ref=sr_1_2?crid=1H0EOMFJO5UJV&keywords=universal+data+model&qid=1664349578&qu=eyJxc2MiOiIwLjAwIiwicXNhIjoiMC4wMCIsInFzcCI6IjAuMDAifQ%3D%3D&sprefix=universal+data+model%2Caps%2C322&sr=8-2 > > > https://www.amazon.com/Accounting-Best-Practices-Steven-Bragg-ebook/dp/B01DCOYF3I/ref=sr_1_3?keywords=accounting+best+practices&qid=1664349689&qu=eyJxc2MiOiIyLjU1IiwicXNhIjoiMi42OCIsInFzcCI6IjIuMTcifQ%3D%3D&sprefix=accounting+best+practices%2Caps%2C294&sr=8-3 > > > One reference I like and refer it many times is this: > > https://github.com/apache/ofbiz-framework/blob/trunk/applications/datamodel/data/seed/AccountingSeedData.xml > See the Credit and Debit entry chart present at line #210. > > You should also spend some time to review the data present inside following > files: > > - AccountingDemoData.xml > - GlAccountDemoData.xml > - OfbizChartOfAccountsData.xml > > >> My concern here, is there any 'Process diagram / workflow > logic' that simplifies the order of using such settings. > > I don't have a straight forward answer or reference of any such Process > Diagram/workflow logic document. > > This is how I would imagine in a real world: > > - A company maintains a General Ledger Accounts to log Credit and Debit > entries. The entries in these accounts can be automated as well as the > provision of manual entries is also required. > - Ledger entries are linked with Invoice and respective Payments. > - Invoices may be associated with Orders. And if required manually entered > Invoices can also be maintained in the system. > - And then time period based reports are there which you can refer > internally as well as you can use those reports to make the Government > happy at the time of Income Tax Return filing. :-) > > I understand that the overall Accounting setup in OFBiz is a complex one, > but if you can ask specific questions then all the SMEs - Accounting will > feel glad to assist you. > > -- > Kind Regards, > Ashish Vijaywargiya > Vice President of Operations > *HotWax Systems* > *Enterprise open source experts* > http://www.hotwaxsystems.com > > > > On Wed, Sep 28, 2022 at 1:50 AM Emad Radwan <[email protected]> wrote: > > > Hello Ashish, > > > > Many many thanks. So much appreciated input from your side as usual. > > Talking about Sharan's work, I already read her book on the subject and > it > > is very interesting and valuable. However, and this is another subject I > > know but thought you may help. I understand that Ofbiz has a rich data > > model and configuration in Accounting around which GL Account to use > > especially when creating automated transactions like those related to a > > sales invoice. > > > > By this, I mean configuration - for example - related to Payment Methods, > > Payment Types, etc. And those other settings that are available via the > > following URL. My concern here, is there any 'Process diagram / workflow > > logic' that simplifies the order of using such settings. In other words, > I > > find it a bit difficult to get the logic from the code having the fact > that > > Ofbiz is using multiple ways of creating services and calling them. So > I'm > > wondering if such flowcharts exist to simplify the logic and explain the > > big picture. > > > > > > > > > https://demo-stable.ofbiz.apache.org/accounting/control/GlAccountAssignment?organizationPartyId=Company > > > > Regards, > > Emad > > > > On Tue, Sep 27, 2022 at 11:51 AM Ashish Vijaywargiya < > > [email protected]> wrote: > > > > > Hello Emad, > > > > > > Following links will be helpful for you: > > > > > > > > > > > > https://demo-stable.ofbiz.apache.org/accounting/control/editPaymentApplications?paymentId=10001 > > > Here you can associate the Invoices with respect to the Payment. > > > > > > > > > > > > https://demo-stable.ofbiz.apache.org/accounting/control/editInvoiceApplications?invoiceId=CI1 > > > Here you can associate the Payments with respect to the Invoice. > > > > > > Sales Invoices can be created in the system by the following ways. > > > > > > 1) When the Sales Order gets completed in the system then a Sales > Invoice > > > gets created in the System. The payment associated with Sales Order > > creates > > > an entry in the system as a "Customer Payment". All the Transaction and > > Gl > > > related postings are done automatically. > > > 2) You can manually create Sales Invoices directly in the system and > with > > > respect to that invoice you can do the manual entry of payment as well > in > > > the system. > > > > > > There are status transitions for Invoices as well as for the Payments > in > > > the system. Following link can help you: > > > > > > > > > https://www.hotwaxsystems.com/ofbiz/ofbiz-ecommerce/ofbiz-invoice-processing-workflow-explained/ > > > > > > Types of Invoices: > > > > > > > > > https://www.hotwaxsystems.com/ofbiz/ofbiz-ecommerce/types-of-invoices-in-ofbiz/ > > > > > > Sharan wrote a wonderful details on Accounting, please refer following > > > links: > > > https://cwiki.apache.org/confluence/display/OFBENDUSER/02+Invoices > > > https://cwiki.apache.org/confluence/display/OFBENDUSER/03+Payments > > > > > > Apache OFBiz provides the flexibility to the users to use the > > > Invoice/Payment data model based on their need. > > > > > > Hope this helps! > > > > > > -- > > > Kind Regards, > > > Ashish Vijaywargiya > > > Vice President of Operations > > > *HotWax Systems* > > > *Enterprise open source experts* > > > http://www.hotwaxsystems.com > > > > > > > > > > > > On Tue, Sep 27, 2022 at 1:17 PM Emad Radwan <[email protected]> > > wrote: > > > > > > > Hello Community, > > > > > > > > I noticed that there's no link in Ofbiz to create a payment > application > > > > from the Payments menu. > > > > > > > > How to apply a payment or part of it to an invoice? What I can think > of > > > is > > > > by creating a GL Transaction! Correct? Or there are other options? > > > > > > > > Please shed some light. > > > > > > > > Regards, > > > > Emad > > > > > > > > > >
