R2 Core
R2 Core
Breadcrumbs

Add ‘Fulfillment Date’ and 'Exchange Rate Date' fields as UDFs in Invoicing entity

                                                                                                                                                                                                       Reference No: AHI-8

                                                                                                                                                                                               Version No: 06.01.02-00

Details:

This enhancement is to add two new fields ‘Fulfillment Date’ and 'Exchange Rate Date' as UDFs in the invoices entity.

  • When the user is adding ‘Fulfillment Date’ and 'Exchange Rate Date' as UDFs, User must define the exact alphabets as ‘Fulfillment Date’ and 'Exchange Rate Date’.

  • These two new UDFs available for all types of Invoice as mentioned below:

  • Invoice Credit Memo

  • Debit Memo

  • Master Bill

  • Summary Invoice (includes sub types: Invoice/Credit/Debit)

  • LR-Invoice

  • Deposit Invoice

  • Standalone Invoice

Fulfillment Date and Exchange Rate Date UDFs creation

 

  1. Launch the R2 application and then click the Maintenance module.

  2. Click User Fields Setup.

  3. Select the Invoice from the list as shown below and then click the Add icon.

https://documentation.r2help.com/mergedProjects/Invoicing/topics/images/AHI-8-1.PNG
Figure 1.0 Select Invoice from the list and then click Add icon

 

  1. Enter the new UDF details and then Click OK button.

https://documentation.r2help.com/mergedProjects/Invoicing/topics/images/A2.PNG
Figure 2.0 Enter details and Click OK button

The added UDFs displays in the User Fields icon in invoicing entity.

Pre-requisites:

An Invoice must be generated for an order. The same procedure to be followed to add the other UDF (Exchange Rate Date).

Sample Workflow:

  1. Go to Invoicing Module and create any type of Invoice (Summary Invoice created to show the sample workflow).

  2. Click User Fields icon as shown below. 

https://documentation.r2help.com/mergedProjects/Invoicing/topics/images/A7.png
Table 3.0 Click User Fields icon

  1. Enter the values for ‘Fulfillment Date’ and ‘Exchange Rate Date’ UDFs. Then, Click OK button.

Ensure to fill in all the mandatory UDFs.

https://documentation.r2help.com/mergedProjects/Invoicing/topics/images/A3.PNG
Figure 4.0 Enter New UDFs values and Click OK button

 

  • System doesn't allow the user to edit the Summary Invoice once it is posted.

  • System doesn't allow the user to modify the Summary Invoice UDFs values once the Summary Invoices are posted.

  • System doesn’t allow the user to modify UDFs definitions, once the data is entered in the UDFs at least in one Summary invoice.

  • UDFs will be removed on regenerating Invoices.

  • Once the UDFs are created, the user can view and enter the values in the following places.

  • Accounts -- > View -- > Invoices

  • Invoicing -- > Search Invoices

  • Order -- > View Invoices

  • AR Invoice Batch -- > For selected invoices added to the batch

  • Accounts -- > View -- > Summary Invoices

  • Summary Invoice/Summary Credit/Summary Debit -- >Edit

  • Standalone Invoice Edit

  • Invoicing-- > View-- > Search Invoices-- > Edit

  • Invoice Search -- > Credit Memo Edit

  • Invoice Search -- > Debit Memo Edit

CR Memo/DB Memo carries the UDFs values from parent invoices
Pre-requisites:

Create Summary Invoice/Invoice and entre the UDF values of 'Fulfillment Date' and 'Exchange Rate Date' and the post the same.

Sample Workflow:

  1. From the Invoicing screen, create a Credit Memo/Debit Memo for the Invoice.

  2. Select the Invoice line and create Credit/Debit Memo.

https://documentation.r2help.com/mergedProjects/Invoicing/topics/images/A4.PNG
Figure 5.0 Select the Invoice line and Create Credit/Debit Memo

  1. Click User Fields icon and view the ‘Fulfillment Date’ and ‘Exchange Rate Date’.

  2. UDFs are carried from the Parent Invoice UDFs. Since the invoice is posted, the fields will be in non-edit able mode.

https://documentation.r2help.com/mergedProjects/Invoicing/topics/images/A6.PNG
Figure 6.0 Fulfillment Date and Exchange Rate Date UDFs carries Parent Invoice UDFs

New Column ‘Due Date’ is added in the AR Batch edit Grid

Details:

In this enhancement, User will be able to see the Due Date in the AR Batch Edit Grid.

https://documentation.r2help.com/mergedProjects/Invoicing/topics/images/A5.PNG
Figure 7.0 Due Date column added in the AR Batch Edit Grid