invoice issue

[dipu]

Hi

can you please help me to find out the reason and solution.
one invoice not posted to GL. Invioce history report it's showing.

Thanks

 

[Kishor Chari]

whats the value of the invoice?

Is it still in the unposted register?

 

[dipu]

No it's not showing in unposted .

 

[shivakumarpatil]

hi,

did u post the invoice using 7.13.4 Invoice Post and do u remember the
GL Effective Date you entered.

With that GL effective date, check in 25.13.14 Unposted Transaction Register, with correct Effective Date and Transaction Type = "SO".

you should get it.

HTH
Shiva

 

[dipu]

Shiva

It's not showing in Unposted transaction register. Is there any solution
to post again ?
Thanks.

 

[dipu]

Shiva

It's not showing in Unposted transaction register. Is there any solution
?
Thanks.

 

[Kishor Chari]

What version are you on.

 

[shivakumarpatil]

dipu,

get into 7.13.1 Pending Invoice Maintenance enter your SO number.
In the last frame, after tax data frame, u have fields
Ready to Invoice: No AND Invoiced: No.
Check these fields. make "Ready to Invoice : yes" and then print using 7.13.3 Invoice Print, update flag as yes, INVOICE number is generated.
Copy that number and then post it using 7.13.4 Invoice Post. A GL transaction will get generated.

HTH
Shiva

 

[dipu]

Shiva

SO number already invoiced and which is showing in 5.13.8 invoice history report but not posted in GL. and There is nothing in Pending invoice.

If i mainten as a pending invoice with the same So then it will generate another Invoice number after post invoice.

I want to post the invoice number which already generated.

 

[oldemanw]

You can check in 27.2 for the batch number and entity:

ardriq.p 1+ 27.2 DR/CR Memo Inquiry 02/06/09
┌──────────────────────────────────────────────────────────────────────────────┐
│ Reference: NL090330 Bill To: 20007912 Open Only: No │
│ Currency: xxxxxxxxxxxxxxxxxxxxxxx │
│ Reporting Currency: Output: terminal │
└──────────────────────────────────────────────────────────────────────────────┘
┌──────────────────────────────────────────────────────────────────────────────┐
│ Reference: NL090330 Type: Invoice Sales Order: 12027323 │
│ Date: 02/06/09 Credit Terms: D030 Amount: 709.24 │
│ Effective: 02/06/09 Entity: 2NL0 Amount Open: 709.24 │
│ Exch Rate: 1.00000 Account: 12000000 0000 │
│ Printed: No Dun Level: 0 Currency: EUR │
│ Contested: No Remark: │
│ Batch: 10036976 │
│ Bill To: 20007912 xxxxxxxxxxxxxxxxxxxxxxxxxxxx Sold-To: 20007912 │
│ Bank: B3 Payment Method: MC │
└──────────────────────────────────────────────────────────────────────────────┘

If the invoice has been posted to the GL, you should be able to find it using 25.13.19:

gltriq.p 1+ 25.13.19 Transaction by Reference Inquiry 02/06/09
┌──────────────────────────────EMEA HEADQUARTERS───────────────────────────────┐
│ Entity: 2nl0 GL Reference: Batch: 10036976 Det Desc: No │
│ Output: terminal │
└──────────────────────────────────────────────────────────────────────────────┘
┌──────────────────────────────────────────────────────────────────────────────┐
│GL Reference Eff Date Entered Batch User ID Corr │
│────────────── ──────── ──────── ──────── ──────── ──── │
│SO090602056864 02/06/09 02/06/09 10036976 axrwolde No │
└──────────────────────────────────────────────────────────────────────────────┘
┌──────────────────────────────────────────────────────────────────────────────┐
│Line Account Project Enty Description Amount Cur│
│──── ────────────────────── ──────── ──── ───────────── ────────────────── ───│
│ 1 80000000-6355 2NL0 Posted Invoic -596.00 EUR│
│ 2 78480000-6355 2NL0 Posted Invoic 11.92 EUR│
│ 3 17000000-6785 2NL0 Posted Invoic -11.92 EUR│
│ 4 12000000-0000 2NL0 Posted Invoic 709.24 EUR│
│ 5 18305000-0000 2NL0 Posted Invoic -113.24 EUR│
│ │
│ │
└──────────────────────────────────────────────────────────────────────────────┘

If the invoice hasn't been posted to the GL, it should show in the Unposted Transaction Register.
Note that you should clear the transaction type field (otherwise you only see the JL types).

This is based on eB2.1SP4