Proposal for custom page to Reverse Cost in transactions by creating Journal Entry

Proposal Summary 

This proposal covers the scope of Custom Page to Reverse Cost in transactions by creating a Journal entry. 

Requirement 

Client would like to develop a Custom page that list the transactions based on selected criteria and create a Journal Entry to reverse the transaction costs. 

Our Solution 

The requirement can be achieved by creating a Custom Page using Suite script.  

The page will have the following selection criteria’s: 

1. From Project (dropdown list) 

2. From Date (date field) 

3. To Date (date field) 

4. To Project (dropdown list) 

All the above criteria will be set as mandatory.  

Once the user selected the criteria’s they can click on the “Search” button upon which the transactions related to the From Project in the specified date range are listed. 

The listed transaction will have the following fields: 

1. Checkbox 

2. Transaction type 

3. Date of Transaction 

4. Entity Name 

5. Expense Account 

6. Amount (Debit) 

7. Amount (Credit) 

8. Department 

9. Class 

10. Location 

11. Project 

12. Product  

13. Sub-cost Center 

The user can select the required transaction from the listed using the Checkbox and click on the button “Reverse Cost”. Upon clicking the Reverse Cost button, a Journal Entry will be created with expense/item lines posted to the To Project and expense/item lines in the reverse manner to From Project. 

Once the button “Reverse Cost” is clicked a message can be shown indicating the user that Journal is creating in the background. After Journal Entry is created successfully the record can be open in a new tab and the current custom page can be reloaded. 

As an expense/item line which is selected once for reverse cost should not be considered again, we can use a custom field of type Checkbox in the expense and item lines of the transactions. The checkbox can be marked “true” if that corresponding expense/item line is added in the Journal. When script checks for expense/item lines related to the From Project, a condition of checkbox is “false” can be used so that the line will not be considered again. 

When listing the GL posting accounts, the following are to be considered: 

• The transactions types such as AP Bill, Bill Credit, Journal Voucher, Write Check, Expense report, and Inventory Adjustment associated with the project will be considered 
• In Bill/Bill Credit transactions, GL posting to the Account Payable of the transaction can be neglected. 

• In Inventory Adjustment transactions, GL posting to the Adjustment Account can be neglected. 
• In Checks, GL posting to the bank account that will be affected by this check transaction can be neglected. 
• In case of Expense lines, which ever account is given in the transaction (irrespective of the account type) can be considered. 
• In case of Item lines, if the item is Non-inventory/Other Charge/Server item, the GL posting to the Asset/Expense account can be considered. 
• In case of Inventory item or Kit/Package item, if the bill/bill credit is standalone transactions GL posting to the Asset/COGS account can be considered. Whereas if the bill/bill credit has related Purchase order then GL posting to the Accrued Purchases account can be considered. 

• If an expense line or item line is entered more than once in a transaction, as the GL posting is done as separate lines without consolidation, we can also show the lines as separate. 

Assumptions 

• The mentioned Project field can be either standard Project field or a custom segment. If custom segment, it is still available in transactions similar to standard Project field. 
• Transactions types considered are Bill, Bill Credit, Journal Entry, Write check, Expense Report, and Inventory Adjustment. 
• From Project and To Project are in same subsidiary. 

• If there are transaction in multiple currencies associated with the From Project, the Journal Entry will be created in the base currency. 
• The Product field in the listed transactions correspond to the standard Item field. It is to be populated only when Item lines in the transaction are selected, when in case expense lines the Product field can be left blank. 
• The Sub-cost center in the listed transactions is directly available in the transaction expense/item lines.