suspense transactions while creating a sales invoice
Locked
suspense transactions while creating a sales invoice
 
|
Hi,
I am creating a sales invoice with the latest ofbiz - partyid = democustomer - Then I click on items menu tab in the invoice screen - I choose GZ-1000 as the product - I choose 4 units - Invoice item type = invoice item product - I clicked on 'add' button - Then I click on 'Add tax' menu item - Then I click on 'sent' button and then the 'Ready' button. - I get the 'suspense transaction' in the Gl Journal. Following are the rows in the Transactions section. Please help me in finding why Gl Journal has Suspense Transactions. Thanks. Acctg Trans Id Acctg Trans Entry Seq Id Is Posted Fiscal Gl Type Id Acctg Trans Type Transaction Date Posted Date Gl Journal Trans Type Description Payment Id Gl Account Id Product Id Debit Credit Flag Amount Orig Amount Organization Party Id Gl Account Type Account Code Account Name GL Account Class Party Reconcile Status Id Acctg Trans Entry Type Id 10010<https://localhost:8443/accounting/control/EditAcctgTrans?acctgTransId=10010&organizationPartyId=Company> 00001 N ACTUAL Sales Invoice 2009-10-19 11:22:54.220 Suspense transactions Sales Invoice 400000 GZ-1000 C $63.96 $63.96 Company 400000 SALES Revenue Not Reconciled _NA_ 10010<https://localhost:8443/accounting/control/EditAcctgTrans?acctgTransId=10010&organizationPartyId=Company> 00002 N ACTUAL Sales Invoice 2009-10-19 11:22:54.220 Suspense transactions Sales Invoice C $3.03 $3.03 Company Utah Sales Tax Authority Not Reconciled _NA_ 10010<https://localhost:8443/accounting/control/EditAcctgTrans?acctgTransId=10010&organizationPartyId=Company> 00003 N ACTUAL Sales Invoice 2009-10-19 11:22:54.220 Suspense transactions Sales Invoice C $0.06 $0.06 Company Utah County, Utah Sales Tax Authority Not Reconciled _NA_ 10010<https://localhost:8443/accounting/control/EditAcctgTrans?acctgTransId=10010&organizationPartyId=Company> 00004 N ACTUAL Sales Invoice 2009-10-19 11:22:54.220 Suspense transactions Sales Invoice 120000 D $67.06 $67.06 Company Accounts Receivable 120000 ACCOUNTS RECEIVABLE Current Asset Customer Not Reconciled _NA_ |
Re: suspense transactions while creating a sales invoice
|
|
Sorry for the last rows of data in the email. It does not appear very
informative in the gmail. To summarise, the last rows shows the data in the transaction section of the orderconfirmation screen. The GlJournal column has 'Suspense Transactions'. Why? Thanks On 10/19/09, bala krishna <[hidden email]> wrote: > Hi, > I am creating a sales invoice with the latest ofbiz > - partyid = democustomer > - Then I click on items menu tab in the invoice screen > - I choose GZ-1000 as the product > - I choose 4 units > - Invoice item type = invoice item product > - I clicked on 'add' button > - Then I click on 'Add tax' menu item > - Then I click on 'sent' button and then the 'Ready' button. > - I get the 'suspense transaction' in the Gl Journal. > Following are the rows in the Transactions section. > Please help me in finding why Gl Journal has Suspense Transactions. > > Thanks. > Acctg Trans Id Acctg Trans Entry Seq Id Is Posted Fiscal Gl Type Id Acctg > Trans Type Transaction Date Posted Date Gl Journal Trans Type > Description Payment > Id Gl Account Id Product Id Debit Credit Flag Amount Orig Amount > Organization > Party Id Gl Account Type Account Code Account Name GL Account Class > Party Reconcile > Status Id Acctg Trans Entry Type Id > 10010<https://localhost:8443/accounting/control/EditAcctgTrans?acctgTransId=10010&organizationPartyId=Company> > 00001 N ACTUAL Sales Invoice 2009-10-19 11:22:54.220 Suspense > transactions Sales > Invoice > 400000 GZ-1000 C $63.96 $63.96 Company 400000 SALES Revenue Not > Reconciled _NA_ > 10010<https://localhost:8443/accounting/control/EditAcctgTrans?acctgTransId=10010&organizationPartyId=Company> > 00002 N ACTUAL Sales Invoice 2009-10-19 11:22:54.220 Suspense > transactions Sales > Invoice > C $3.03 $3.03 Company Utah Sales Tax Authority Not Reconciled > _NA_ > 10010<https://localhost:8443/accounting/control/EditAcctgTrans?acctgTransId=10010&organizationPartyId=Company> > 00003 N ACTUAL Sales Invoice 2009-10-19 11:22:54.220 Suspense > transactions Sales > Invoice > C $0.06 $0.06 Company Utah County, Utah Sales Tax Authority Not > Reconciled _NA_ > 10010<https://localhost:8443/accounting/control/EditAcctgTrans?acctgTransId=10010&organizationPartyId=Company> > 00004 N ACTUAL Sales Invoice 2009-10-19 11:22:54.220 Suspense > transactions Sales > Invoice > 120000 D $67.06 $67.06 Company Accounts Receivable 120000 ACCOUNTS > RECEIVABLE Current Asset Customer Not Reconciled _NA_ > |
|
|
Hi Bala
I duplicated your test and then did a verify transaction on your accounting transaction for this Sales Invoice and got the following errors: The following occurred: Not posting GL Accounting Transaction with ID [10000] because the trial balance failed: Debit Total=67.06 Credit Total=67.05 Debit/Credit Difference=0.01 Gl account id is not set for [00002] or mapping not found for account type Gl account id is not set for [00003] or mapping not found for account type These are the reasons why your Sales Invoice is going to the suspense journal. The first one is to do with rounding. (I think some work is already in progress to sort this type of rounding error out) Looking at the second and third ones – I think this is a bug. When you press the 'Add Tax' the GL accounts '224153' are automatically filled in as the GL accounts but the tax entries are not being posted to this account. In fact when you look at the accounting transaction there is no GL account associated with the tax entries and there should be (since it was defaulted when you created the invoice). I think you should create a Jira issue for this. Thanks Sharan
|
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |