Financials – Page 9 – knowledgebase JJ

Consolidated subsidiary is not available under the subsidiary fields in the report.

Create Foreign Currency Variance Posting Rules >

Scenario Customer ran the Revalue Open Currency Balances task in the Period Close Checklist and got the following error: “Bulk Processing Abnormal Termination” If the Foreign Currency Variance Mapping under Setup > Company > Enable Features > Accounting tab > Advanced Features section is currently enabled, we are required to create rules for the posting of Unrealized Gain/Loss from currency revaluations. When creating rules under Setup >… Continue reading Create Foreign Currency Variance Posting Rules >

Intercompany vendor not listed in Advanced JE line level

When an intercompany JE-advance created, Intercompany vendor is not listed solution: The currency in the advance JE should be added to the intercompany vendor currency list. Then only it will list as vendor name in the drop down at line level of JE

Tax Reports(international) – UK 2021

Tax Reports (international) is generates the VAT 100 report and submit to the HM Revenue and Customs. Always make sure that tax code set up is correct while generating the report. This report generates the United Kingdom VAT100 Return. Each boxes in the report includes VAT due on sales and other outputs, VAT due in… Continue reading Tax Reports(international) – UK 2021

SKUs-How to list Item groups with its components.

item groups with sku

How to work the formula even if some columns are blank in Saved Search

We can execute the formula even if some columns are blank in Saved Search using the following:-Navigate to1. Lists > Search > Saved Search > New 2. Select the Type of the search3. On the Results tab , Column Subtab;Field – Formula Numeric Formula : NVL({location on order},04. Save and Run

Scheduled Email through Saved Search

Scheduled email serves a regular update on the saved search results. Saved search results mailed according to the scheduled and also gives alerts when there is any add or update. it can be sent from search owners email address, or default address as company preferred. and also we can customize the content on the message… Continue reading Scheduled Email through Saved Search

Vendor statement

vendor_statement_customization

Use multiple pricing

Scenario Define price level in the customers record. Solution Enable the Multiple Pricing feature: Your administrator can go to Setup > Company > Setup Tasks > Enable Features. On the Transactions subtab, check the Multiple Prices box. Click Save. Create price level records: To create price levels, go to Setup > Accounting > Setup Tasks > Accounting Lists > New. Set price… Continue reading Use multiple pricing

Category: Financials