Hi Rees,there are several services in GeneralLedgerServices.xml that use the "set" operation to pass the BILL_FROM_VENDOR role to the createAcctgTransAndEntries service, that internally calls the getGlAccountFromAccountType service that is where the field is looked up in the db.
Hope it helps, Jacopo On Sep 12, 2008, at 7:01 PM, Rees Watkins wrote:
HiI can't find the particular reference to BILL_FROM_VENDOR that effects this behavour.Thanks Rees ----- Original Message ---- From: BJ Freeman <[EMAIL PROTECTED]> To: [email protected] Sent: Friday, 12 September, 2008 17:35:17 Subject: Re: Accounts Payable and Suppliers as of svn 691430 I found many references to BILL_FROM_VENDOR particularly applications\accounting\src\org\ofbiz\accounting\invoice Rees Watkins sent the following on 9/12/2008 6:18 AM:Hi JacopoI was looking at the OFBiz code to see how using BILL_FROM_VENDOR effects Accounts Payable for secondary accounts that I setup in General ledger->Setup->GL Account Defaults->Party GLI can't find the place in the code where the decision is made to modfy the glAccountTypeId based on the BILL_FROM_VENDORrole. ( I did a search for BILL_FROM_VENDOR over the whole code base. )In this service: <simple-method method- name="getGlAccountFromAccountType" short-description="Look up a GlAccountId from GlAccountTypeId">It seems to copy the values unconditionally without taking the BILL_FROM_VENDOR role into account. Can you tell me where in the code the role influences the account posting for secondary ledgers?Thank you Rees ----- Original Message ---- From: Jacopo Cappellato <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, 13 August, 2008 22:09:34 Subject: Re: Accounts Payable and Suppliers Rees, I finally had another look at the setup; the problem was the roleTypeId associated to the supplier in the PartyGL mapping screen: it was required "bill from vendor" instead of "supplier": https://demo.hotwaxmedia.com/accounting/control/editPartyGlAccounts?organizationPartyId=Company I changed it and I was able to post the transaction (see invoice 10001) in the proper account. Hope this helps you, Jacopo On Aug 13, 2008, at 9:08 PM, Rees Watkins wrote:Fantastic - thanks Setting up DemoSupplier Accounts Payable Sub ledger on https://demo.hotwaxmedia.com/accounting/control/ListGlAccountOrganization?organizationPartyId=Company Create an entry in the Global Chart of Accounts: 210500 ACCOUNTS_PAYABLE - DemoSupplier I did this by going to Global GL Settings->Chart Of Accounts-Navigate Accounts - created entry and hit update.Possible issue: My new account appears in Global GL Settings->Chart Of Accounts->Navigate Accounts. But if I go to the Global GL Settings->Chart Of Accounts it is not there Created Assignment in General ledger->Setup->Chart of Accounts (for Company). Added to General ledger->Setup->GL Account Defaults->Party GL Accounts. PartyID :DemoSupplier Role Type ID :Supplier Gl Account Type Id :ACCOUNTS_PAYABLE GL Account ID : 210500 ACCOUNTS_PAYABLE - DemoSupplier Raise a purchase invoice 10001 (ignore 10000 as I messed that one up) from DemoSupplier to Company. Marked invoice as Approved. I posted the invoice to the accounts - Set Status to Ready You can see the accounting entires on the invoice. ACCOUNTS payable has a Credit of $100 Purchase Order Adjustments has a debit of $ 100 I have not raised a payment to assign to the invoice - as posting to accounts is enough to raise entries to show my issue. Tried again with amount of $77 and purchase invoice type of Invoice Finished/Digital Looking at General ledger->Setup->Chart of Accounts (for Company).there are no entries for ledger 210500 ACCOUNTS_PAYABLE - DemoSupplierThere is an entrie in 210000 Accounts payable. Trial balance shows no entires. Any points would be very helpful. Kind regards Rees ----- Original Message ---- From: Jacopo Cappellato <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, 13 August, 2008 2:29:35 PM Subject: Re: Accounts Payable and Suppliersyeah, it has been tested, but since the code there is pretty young and changes pretty quickly (or at least, this is what happened a few timeago) it is possible that something has been broken.If you could setup an example in the demo server I will have a look atit. The demo server is here: https://demo.hotwaxmedia.com/accounting/control/main Kind regards, Jacopo On Aug 13, 2008, at 1:39 PM, Rees Watkins wrote:I appreciate everyones help and have read everything I can find on this topic including all discussions on this group. I added a entry in the chart of accounts: Accounts Payable - DemoSupplier as a child of Accounts Payable. I made the association shown below in Jacopo's mail. Raised a purchase order from DemoSupplier to Company. There are no entries in the sub ledger for Accounts Payable - Demosupplier. Has anyone else tried this and found it to create an entry in the sub ledger? ----- Original Message ---- From: BJ Freeman <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, 13 August, 2008 12:58:36 PM Subject: Re: Accounts Payable and Suppliers bump this up relative to the sub ledger discussion. Jacopo Cappellato sent the following on 7/30/2008 4:40 AM:On Jul 30, 2008, at 1:36 PM, Rees Watkins wrote:You just have to change the last field "GL Account ID" to match theHi Jacopo There are no documents or examples on how this is used. Could you please give me some pointers because I have not been able to get this to work. In Accounting->General Ledger->SetUp->Party Gl Accounts PartyID :DemoSupplier Role Type ID :Supplier Gl Account Type Id :ACCOUNTS_PAYABLE GL Account ID : 210000 ACCOUNTS_PAYABLEaccount to which you want to post the transaction for the accounts payable of supplier DemoSupplier. It should work, JacopoIf I raise an purchase invoice from DemoSupplier to Company I do not see any change in my accounts as a result of changes to Accounting->General Ledger->SetUp->Party Gl Accounts I see no entries to DemoSupplier.Where should I see this transaction to DemoSupplier show. Nothing under party, no changes to trial balance etc. Have I done this correctly? Am I looking in te wrong please. Thanks Rees ----- Original Message ---- From: Jacopo Cappellato <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, 30 July, 2008 1:06:57 PM Subject: Re: Accounts Payable and Suppliers You should use this screen to configure the specific accounttype/ account mapping for your suppliers: https://demo.hotwaxmedia.com/accounting/control/editPartyGlAccounts?organizationPartyId=Company Jacopo On Jul 30, 2008, at 12:39 PM, Rees Watkins wrote:Hi When I receive and enter an invoice from a supplier the system posts to Accounts Payable. I would like to have an Account for each supplier to show the total owed to themDo I use Party Financial Accounts to do this? If so how do I postto the Supplier Account? Thank you Rees __________________________________________________________ Not happy with your email address?. Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html__________________________________________________________ Not happy with your email address?. Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.htmlSend instant messages to your online friends http:// uk.messenger..yahoo.comSend instant messages to your online friends http://uk.messenger.yahoo.com
smime.p7s
Description: S/MIME cryptographic signature
