Understanding the Advance Invoice Line-Level Application

Understanding the Advance Invoice Line-Level Application

Overview

A new way of applying advance invoice to final invoices has been introduced in the Poland Localization SuiteApp bundle version 3.9.10. This new version supports applying prepayments at the individual line-item level. In effect:

  • When an advance invoice contains multiple item lines, each advance line is only used to settle its matching line on the final invoice.

  • For example, if there are three lines on the advance invoice,

    1. the first advance line applies exclusively to the first line of the final invoice,

    2. the second to the second,

    3. and the third to the third.

  • Each line-level advance application must not exceed the advance invoice amount for that line.

Configuring Line-Level Advance Invoices

To ensure each advance line remains matched throughout the entire invoicing process, a new field from Sales Order’s line level named Advance Invoice Line ID will be carried forward at every step: Advance Invoice, Advance Invoice Correction, Final Invoice, Advance Invoice Application.

To ensure that the process is working as designed, make sure to display the field Advance Invoice Line ID in the line level of the following transaction forms:

  • Sales Order

  • Advance Invoice

  • Advance Invoice Correction

  • Final Invoice

  • Advance Invoice Application

To identify the default transaction forms used for advance invoice process, you may check in your Poland Localization Settings:

  1. Navigate to Setup > Staria Poland Localization > Poland Localization Settings.

  2. From the list, click View next to the Poland Localization Setting that you want to check.

  3. Then, navigate to the Sales Invoicing Subtab.

  4. Under the Advanced Invoice field group, you will see the default forms used for the transactions.

Note: If the Advance Invoice Line ID is missing from the chain, then, the previous behavior (full reversal of advance invoice) of advance application will take effect. To use the new mechanism for advance invoice application for those existing transactions, you need to add the Advance Invoice Line ID to the existing transactions.

Understanding the Advance Invoice Line-Level Application

Below is a simple example showing how each advance-invoice line is matched to its final-invoice line—and how only the correct amounts are applied.

Advance Invoice

Total prepayment: PLN 1 050,00

Line #

Item

Qty

Unit Price

Advance Amount

Advance Invoice Line ID

Line #

Item

Qty

Unit Price

Advance Amount

Advance Invoice Line ID

1

Product 1

1

150

150

aaaa111133339990

2

Product 2

1

400

400

aaaa111133339991

3

Product 3

1

500

500

aaaa111133339992

Final Invoice

Only Lines 1 and 3 are billed

Line #

Item

Qty

Unit Price

Advance Amount

Advance Invoice Line ID

Line #

Item

Qty

Unit Price

Advance Amount

Advance Invoice Line ID

1

Product 1

1

300

300

aaaa111133339990

3

Product 3

1

1000

1000

aaaa111133339992

Advance Invoice Application

Only matching lines are applied, and amounts never exceed the original prepayment

Line #

Item

Advance Amount

Advance Invoice Line ID

Line #

Item

Advance Amount

Advance Invoice Line ID

1

Product 1

150

aaaa111133339990

3

Product 3

500

aaaa111133339992

Please take note of the following:

  • Only Lines 1 & 3 are settled—because only those were invoiced.

  • Applied amounts match the original prepayments and never exceed them.

  • Line 2 remains open (no final invoice), so its prepayment is untouched.

©2024 Staria. All rights reserved. No part of this publication may be reproduced, distributed, or transmitted in any form or by any means, including photocopying, recording, or other electronic or mechanical methods, without the prior written permission of the publisher.