Re: Accounts Payable and Suppliers
Locked
Re: Accounts Payable and Suppliers
 
|
Re: Accounts Payable and Suppliers
|
|
Re: Accounts Payable and Suppliers
|
|
Re: Accounts Payable and Suppliers
|
|
Re: Accounts Payable and Suppliers
|
|
Re: Accounts Payable and Suppliers
|
|
In reply to this post by Rees Watkins
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: > Hi > > I can't find the particular reference to BILL_FROM_VENDOR that > effects this behavour. > > Thanks > Rees > > > > ----- Original Message ---- > From: BJ Freeman <[hidden email]> > To: [hidden email] > 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 <[hidden email]> >> To: [hidden email] >> 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 <[hidden email]> >>> To: [hidden email] >>> 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 <[hidden email]> >>>> To: [hidden email] >>>> 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 <[hidden email]> >>>>>> To: [hidden email] >>>>>> 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 >> >> >> > > |
smime.p7s (6K) | Free forum by Nabble | Edit this page |