What's new in version 20.202301.0.0

Release Note • 7/6/2023 • 9 min read

Features

PBI No.Description
202691Create Corrective Financial Invoice
230135Apply entries should split journal lines by posting group
232603Blanket order enhancement on document and posted document on the pages (FND; for Events)
233421Default reason code for Blanket Order with the blanket Order Type
235373Apply entries should split journal lines by posting group - Part 2

Resolved issues

PBI No.Description
233893Blanket order enhancement (FND) (a.o for Events) - findings
236116Solve Item Charge Assignment for in SPC Periodic Settlement documents in the new BC Qty. To Handle field

PBI 202691 - Create Corrective Financial Invoice

What

Correct order based invoices financially.

Why

Standard BC functions to correct or cancel a posted sales invoice works fine for non order based invoices. For order (inventory) based invoices it will post new item ledger entries for the return receipt and new entries for the shipment of the corrective order/invoice.

That will not work for locations with warehouse activities. In addition (locations without warehouse activities) it may not be wanted to post new goods movements (fictive movements, not real) for (excise) tax reasons and for the reference to the shipment no (the new corrective (EDI..) Invoice will not refer to the the original delivery note).

New similar functions were added to the posted sales invoice page for corrective financial invoices. These corrections (both the credit memo and the new corrective invoice) maintain the relation to the original shipment no and post value entries only related to the original item ledger entries.

How

Search for Posted Sales Invoices. Open the invoice to be corrected. Click Actions - Correct Financial - Correct Financial. The corrective credit memo is posted and the new (corrective) sales invoice page opens. Correct the invoice (different prices…) and post it.,

Search for the posted credit memo (corrective) and the posted sales invoice (corrective) and notice the reference to the original sales shipment no(s) in text lines plus item lines and by the Find Entries action (value entries posted related to the original item ledger entries)

When you select Cancel Financial action, you should create the corrective invoice later on. Then open the posted sales invoice (to be corrected) again and click on Actions - Correct Financial - Create Document - Create Financial Corrective Invoice. Make corrections in the new invoice and post it.

When using the Create Financial Corrective Invoice function, if the Posting Date on the selected Sales Invoice isn’t valid, a new posting date is determined based on the first open accounting periods and/or allowed posting date settings on the general ledger setup and/or user setup.

If this new posting date differs from the posting date of the Posted Sales Invoice, a confirmation message will appear.

Select Yes to post the credit memo with the new posting date, and to generate a corrective financial invoice with the same new posting date.

TheCorrect Financial functions only work for orders that were invoiced from an invoice document (combine shipments, create periodic invoices, get shipment lines).

PBI 230135 - Apply entries should split journal lines by posting group

What

Apply entries in a general journal with split line per posting group.

Why

In Aptean Beverage, the posting group is used to specify the different types of entries. The normal posting group for regular invoices of goods (beverage) deliveries, and other posting groups for areas like contract management loans, rental agreements or a separate posting group for deposit invoices. Then it is important to

When applying open entries in a general journal by the Apply entries function, the user can set an ID to entries with different posting groups. In that case the journal lines should be split conform, as each journal line should contain the same posting group as the entries it is applied with.

How

Search for any general journal, like the Cash receipt journal. Select a customer that has open entries with different customer posting groups. Fill in the amount that is paid. Click on the Apply Entries action, set an ID on all entries and close the page with [OK].

The journal line has now been split with a line for each posting group that was selected, each line containing that posting group. The document no. has been split as well in a sequential no (eg. BANK001-001, BANK001-002..) and the Applies-to ID in the selected entries has been set to that as well. Post the journal and open entries will be all applied to the journal line with the conform posting group.

The same for applying vendor entries.

PBI 232603 - Blanket order enhancement on document and posted document on the pages (FND; for Events)

What

Blanket order type and Blanket order No. in all sales and purchase documents, unposted and posted.

Why

Blanket orders can be used for different reasons, for call-off contracts, for pre-orders, back-orders, for event orders. Companies want to be able to indicate that and be able to filter out orders, shipments, receipts and invoices by that.

How

Search for Blanket Sales Orders. Create a new blanket order. on Foundation FastTab, select a Blanket Order Type (blank, Event, Back-order,Pre-order).

Create lines and click on action Make Order. Open the sales order. View the blanket order type and blanket order no. in the header on FastTab Foundation, and in the order list page (personalize: add the fields).

Post the shipment and invoice for the order. Open the posted sales shipment and view the blanket order type and -no. on FastTab Foundation and in the list page (personalize: add the fields). Open the posted sales invoice and view the blanket order type and -no. on FastTab Foundation and in the list page (personalize: add the fields).

Search for Blanket Purchase Orders. Create a new blanket order. on FastTab Foundation, select a Blanket Order Type (blank, Event).

Create lines and click on action Make Order. Open the purchase order. View the blanket order type and blanket order no. in the header on FastTab Foundation, and in the order list page (personalize: add the fields).

Post the receipt and invoice for the order. Open the posted purchase receipt and view the blanket order type and -no. on FastTab Foundation and in the list page (personalize: add the fields). Open the posted purchase invoice and view the blanket order type and -no. on FastTab Foundation and in the list page (personalize: add the fields).

PBI 233421 - Default reason code for Blanket Order with the blanket Order Type

What

Default reason code for Blanket Order with the blanket Order Type

Why

Blanket orders created for events may have special event conditions that are triggered based on a reason code for that.

How

Search for Foundation Setup, open FastTab Default Reason Codes.

Select a reason code in field Sales Blanket Order Reason Code. Select a reason code in field Sales Blanket Order (Event) Reason Code.

Search for Blanket Sales Orders. Create a new blanket order. Field Reason code is filled in the header with the (standard) reason code selected for the blanket order. Open FastTab Foundation and set field Blanket Order Type to Event. Now the reason code is changed to the blanket order reason code for events. Set the Blanket Order Type to blank, Backorder or Pre-order and the reason code will be changed to the standard reason code again for blanket orders.

Search for Foundation Setup, open FastTab Default Reason Codes.

Select a reason code in field Purchase Blanket Order Reason Code. Select a reason code in field Purchase Blanket Order (Event) Reason Code.

Search for Blanket Purchase Orders. Create a new blanket order. Field Reason code is filled in the header with the (standard) reason code selected for the blanket order. Open FastTab Foundation and set field Blanket Order Type to Event. Now the reason code is changed to the blanket order reason code for events. Set the Blanket Order Type to blank and the reason code will be changed to the standard reason code again for blanket orders.

PBI 235373 - Apply entries should split journal lines by posting group

What

Apply entries in a general journal with split line per posting group.

Why

In Aptean Beverage the posting group is used to specify the different types of entries. The normal posting group for regular invoices of goods (beverage) deliveries, and other posting groups for areas like contract management loans, rental agreements or a separate posting group for deposit invoices. Then it is important to

When applying open entries in a general journal by the Apply entries function, the user can set an ID to entries with different posting groups. In that case the journal lines should be split conform, as each journal line should contain the same posting group as the entries it is applied with.

How

Search for any general journal, like the Cash receipt journal.

Select a customer that has open entries with different customer posting groups. Fill in the amount that is paid. Click on the Apply Entries action, set an ID on all entries and close the page with [OK].

The journal line has now been split with a line for each posting group that was selected, each line containing that posting group. The document no. has been split as well in a sequential no (eg. BANK001-001, BANK001-002..) and the Applies-to ID in the selected entries has been set to that as well. in case there is an unapplied amount, the original journal line will contain that amount, unapplied with the regular posting group.

Post the journal and open entries will be all applied to the journal line with the conform posting group.

The same for applying vendor entries.

PBI 233893 - Blanket order enhancement (FND) (a.o for Events) - findings

What

Blanket orders contain 3 new ‘event’ fact boxes: Loan in Use, Full goods and an Empty goods fact box to show the balances per (event) blanket order. They did not show the correct items. That has been resolved.

PBI 236116 - Solve Item Charge Assignment for in SPC Periodic Settlement documents in the new BC Qty. To Handle field

What

A new field Qty To Handle was introduced in BC21. This could cause an issue in the automatic item charge assignment of Drink-it attached lines (for taxes, for conditions) and in periodic settlement documents (conditions). That has been resolved.