Opening stock can be uploaded with MAP.
However, historical maintenance of sales price and cost price is an important things to be there in the system.
1 09/22/2020 10:02:55 am
Re: Periodic sales & purchase price maintenance (2 replies, posted in Items and Inventory)
2 09/21/2020 08:04:01 am
Re: Month End/Year End Process, Fiscal months closing (4 replies, posted in Setup)
Thanks a lot for your quick help.
However, reopening of the posting period might be possible from UI (Front End)
3 09/21/2020 06:45:29 am
Topic: Periodic sales & purchase price maintenance (2 replies, posted in Items and Inventory)
Sales and Purchase price for Items can be maintained for a specific date range.
When a sales/purchase invoice for a specific date will be posted, the system will pick the sales pricing maintained for that date.
This will also help to have a historical price data for any items.
Standard costing may not be maintained for purchased items. Instead of standard cost, moving average price (MAP) can be maintained for purchased items. Standard costs can be used for Manufactured Items.
For purchased items, standard costing can be deactivated.
Please help, we can discuss it.
4 09/21/2020 05:00:27 am
Topic: Month End/Year End Process, Fiscal months closing (4 replies, posted in Setup)
Fiscal year can be closed by marking the same in Fiscal year settings.
is there any way to close months so that backdated posting can be controlled by admin.
For Example, the current month is September 2020, I would like to close posting for July & August 2020 (1st and 2nd month of 2020-2021 Fiscal year). If required, the closed months can be opened only by admin-level users.
Thanks in advance.
5 08/31/2020 07:24:02 am
Re: Dimension wise balance sheet items (A/C Payable and Receivables) (11 replies, posted in Dimensions)
Thanks a lot @Joe
6 08/05/2020 11:05:02 am
Topic: Dimension wise balance sheet items (A/C Payable and Receivables) (11 replies, posted in Dimensions)
I got P&L items that can be split dimension wise but balance sheet items like A/C payables and A/C receivables can't be split dimensionwise.
For a supplier invoice,
Dr. GR/IR Clearing - There is a dimension
Cr. A/C payable - There is no dimension
For a customer invoice:
Dr. A/c Receivable (Customer) - There is no dimension
Cr. Sales - There is a dimension
The end result is, the trial balance/P&L/Balance sheet can not be segregated dimensionwise. In whole trial balance, there is a balance in Sales, COGS, inventory, A/c. Payable, A/c. receivable but in dimensions TB there is no value in the receivable and payable account. Need help in this. We want to have dimensions for both the payable and receivable accounts.