suspense transactions while creating a sales invoice

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

suspense transactions while creating a sales invoice

bala krishna
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_
Reply | Threaded
Open this post in threaded view
|

Re: suspense transactions while creating a sales invoice

bala krishna
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_
>
Reply | Threaded
Open this post in threaded view
|

Re: suspense transactions while creating a sales invoice

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

bala krishna wrote
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 <balakrishna@veersoftsolutions.com> 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_
>