GOAL for cost allocation: Full report of payments (in each bank) with the cost allocation of what has been paid linked. How can we achieve this?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To achieve a full report of payments (in each bank) with the cost allocation of what has been paid linked, you can use a combination of NetSuite's built-in features and custom SuiteScript. Here are the steps you can follow: 1. Payment Allocation: In NetSuite, you can allocate payments to customers by navigating to the Bank Statement List, picking a statement, editing it, and allocating the payment to the customer based on the description. You can then pick which invoice it relates to and save and submit. If you cannot allocate an invoice, it creates a Journal. 2. Handling Different Currencies: If you need to allocate customer payments in one currency to invoices in another currency, you have two options. If the bank account is in the subsidiary base currency, you can choose the other currency in the customer payment window. Otherwise, you'll need to create additional transactions (Journals) to transfer the debt to the other currency. 3. Expense Allocation Across Departments: If you need to dynamically allocate an expense across departments based on % of total revenue, you can use Statistical Schedules and Allocation Schedules. You can create a statistical account for this purpose with the unit type as 'Dollars'. 4. Allocation Based on Debit or Credit: If you need to use different accounts based on whether an account has a debit or credit amount, you can tag the debit amount and credit amount to different segmentations and use that in the allocation criteria. 5. Reporting: Finally, you can create a custom report or saved search in NetSuite to pull all this information together. You can include fields such as the bank, payment amount, allocated cost, and related invoices. If necessary, you can use SuiteScript to further customize this report. Remember, this is a high-level overview and the exact steps may vary based on your specific NetSuite setup and business requirements.