on
RE:
For customers convert from GP, they have Edit List report before post Payment and Cash Receipt. The report including applied invoices. And generate by Batch. Now in BC, they have to click on each line, to see the applied invoice detail. Also, nothing to save as a report before approval. It is super stupid, manager need to click on 100 lines to see which invoice is paid and approve. We have to customize to give customer a proper report. They can view before posting for all transactions in a batch include apply detail.
RE:
Also, Fixed Asset list page is better to have more columns by personalize. Our customer convert from GP. They can get a list include both FA general and book information. Now have to check different places/reports. Even a serial No. from FA card, we need design to add into Fixed Asset list.
RE:
We have a lot customer convert from GP to BC. GP's management reporter is very easy to use. But in BC they have to consider JetReport (with extra cost) or PowerBI (need developer help them), majority we can use Financial Report (Prior NAV's Account schedule) to build. But formula in BC/NAV is really not user friendly. Also, many function with MR (such as add Vendor ID/Customer ID into drill down detail, or group by vendor ID for expense, group by customer ID for sales etc.) can't do with BC Financial report.Hope Microsoft can get MR work with BC (Similar as FO or prior GP). Or improve Financial report function.
RE:
Although BC default has Dimension correction tool. Our customer still asked us to create customization for them to modify Dimension value. From Customer ledger, Vendor ledger or Item ledger, select the line they want to change. Click on Edit dimension (customized button), they can change value, then click on update. The change will flow to GL and other subledger tables.
RE:
For our customers, there are 2 option.Manual: change PO or SO line Qty to Same as posted shipment/invoice, change remainning Qty = 0 Create Customization: add a button 'Mass Close SO' ' Mass Close PO'. In Pop up window, type in range. The selected range will show in SO list or PO list. Click on 'Process'. Customization will do, Change remainning Qty to 0. Move SO/PO from open list to Archived SO/PO. Move Sales line/Purchase line to Archived Sales line/Purchase line.
RE:
As a workaround, we use unrealized gain/loss account in Currency setup, realized gain/loss account fields. It is not a perfect solution, but will save some time if accounting need to do a journal to reclass from Realized gain/loss to Unrealized gain/loss.
RE:
There is a workaround. We changed My Settings >> Work Date To a future date, If recurring journal next post date is before work date, it should be able to post.
RE:
It is common accounting don't want users to change, or even view Vendor's Bank account. Have a workflow function will be great, currently, we use User Permission and Change Log to control and track Vendor Bank account and Customer Bank account.
RE:
Completely agree - I needed this feature yesterday.Why this was not part of the original design completely baffles me.
RE:
(four and a half years later, but....)Completely agree - the PowerBI Service is in desperate need of all kinds of visibility metrics.