what program flow are you expecting. The General ledger does not deal with roles, as far as BILL_FROM_VENDOR.
Rees Watkins sent the following on 9/12/2008 10:01 AM: > Hi > > I 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 Jacopo >> >> I 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 GL >> >> I 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 - DemoSupplier >>> There 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 Suppliers >>> >>> yeah, 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 time >>> ago) it is possible that something has been broken. >>> If you could setup an example in the demo server I will have a look at >>> it. >>> 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: >>>>> >>>>>> Hi 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_PAYABLE >>>>> You just have to change the last field "GL Account ID" to match the >>>>> account to which you want to post the transaction for the accounts >>>>> payable of supplier DemoSupplier. >>>>> >>>>> It should work, >>>>> >>>>> Jacopo >>>>> >>>>>> If 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 them >>>>>>> Do I use Party Financial Accounts to do this? If so how do I post >>>>>>> to >>>>>>> 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.html >>>> Send instant messages to your online friends http:// >>>> uk.messenger..yahoo.com >>> Send instant messages to your online friends http://uk.messenger.yahoo.com >> >> > > >
