Skip to main content
Question

Reconciliation of not yet invoiced charges


Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • 6 replies

Hello,

I am looking for a way to reconcile my account “not yet received invoices - charge”.

The report “not yet invoiced” does not help since It will show only the receipts but not the charges in the PO.

We defined a dedicated account in the posting controls to book the receipts of charge but I have no details to justify to our auditors the balance.

The matching of this account is not a viable solution since there are thousand of transactions and the automatic matching  gave poor results.

 

Basically, this reconciliation should be part of the report “not yet invoiced” but either there is a bug in the report or a missing functionality.

 

Any clue how to make this reconciliation ?

 

Thank you

 

3 replies

cperdue
Hero (Partner)
Forum|alt.badge.img+14
  • Hero (Partner)
  • 439 replies
  • May 9, 2023

We have built reports that combine the lines and charge lines.


Furkan Zengin
Ultimate Hero (Partner)
Forum|alt.badge.img+21
  • Ultimate Hero (Partner)
  • 737 replies
  • May 9, 2023

Hi @AlainK 

@cperdue is right, you can create a report. 

I think you can create a quick report combining GEN_LED_VOUCHER_ROW_UNION_QRY and MAN_SUPP_INVOICE_POSTINGS

I am assuming your posting controls are M187 and M189 for the charges. So create a query on GEN_LED_VOUCHER_ROW_UNION_QRY with transaction code M187 and you will have PO number in reference number field. Join this information with MAN_SUPP_INVOICE_POSTINGS PO number field where posting type is M187.

Hope it is clear

Thanks

 


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 6 replies
  • May 9, 2023

Hi,

Thank you for your answers.

I will try to create the quick report. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings