You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by bala krishna <ba...@veersoftsolutions.com> on 2009/10/19 08:08:41 UTC
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
Posted by Sharan-F <sh...@gmail.com>.
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 <ba...@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_
>>
>
>
--
View this message in context: http://n4.nabble.com/suspense-transactions-while-creating-a-sales-invoice-tp253257p253452.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: suspense transactions while creating a sales invoice
Posted by bala krishna <ba...@veersoftsolutions.com>.
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 <ba...@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_
>