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 > > > > > >
