-
Employee Turnover chart report grouped by months
Hi am trying to create a report that should calculate the turnover(Total number of leavers in a period / Total number of employee in that same period X 100) and the report should also group the turnover per month. I was able to get the turnover for the whole period but not per ,month. kindly assist.
-
How does NAV Calculate the profit percent, usually the formula can be unitcost(1+profit%).
The profit calculation formula being used is price =cost + profit. So when the unit cost is 100 with a profit % of 20 then the unit price should be 120. But Nav uses a different formula for that that gives the unit price as 125. Just need help understanding how does the formula used in NAV…
-
How can i make sales orders to b approved after prepament invoce has bees been released
hi. l created a sales order and it require the sales order first to be approved before posting invoice. Yet the process i want is for the prepayment invoice first to be posted and the document to send for approval to the dispatch clerk(the one who will dispatch the goods) since the dispatch clerk can only dispatch if there…
-
How to create a Date filter in a report and a page?
When you want to choose the date which you can obtain the data you want from a table through the Date filter,what can you do?
-
EFT Payment Export with Bank of America
Hello greetings. Has anyone built the Data Exch Def setup for EFT Payment Export with Bank of America and Business Central?
-
How to apply a payment(LCY) to a sales invoice(FCY)
Customer->Customer ledger entries-> Apply a payment with local currency to a sales invoice with foreign currency -> Set applies to ID- can’t apply because there’s a balance available. What should I do in this scenario?
-
Import Payrolls in Business Central
I have been trying to customize my input file to import into the General Journal. The steps I have taken are: 1. Install the Ceridian Payroll extension. 2. Create a new “Data Exchange Definition”. 2.1. Configure the Reading / Writing field with the xmlport 1220 (Date Exchange Import Csv) 2.2. Create a new line definition.…
-
is the balance 0 when you close the year
hello. I am looking at my detail trial balnace report and I am thinkinng shouldnt the balance be 0 if i have closed the year
-
I couldn't post my Purchase Invoice after selecting GST structure.
When i post my Purchase invoice,system is throwing me following error, "Gen. Prod Posting Group must have a value in Purchase line XXXX". But the same Purchase invoice is getting posted when i remove my GST tax structure. Also, in few cases there is no error while posting Purchase Invoices with GST structure for same line…
-
Adjust Cost - Item Entries Job failed
I hope that i can found any help in the issue below: We have job to adjust cost but later it is failed with the error message : ExeID SE:0000000065;DT:GLREG=45;DI:C12;T81;OnCode Not Found Any one face this issue or have any information can help us to solve this problem
-
I got some differences on General Ledger and Sub Ledgers in some accounts like packing materials.
Please if you support me how can i solve some differences on General Ledger and Sub Ledgers in some accounts like packing materials and main product produced by production order.
-
[NAV 2018, Standard] Customer Ledger Entry not allowed to Reverse in case of Realized Gain/ Loss
Hello everyone, I encountered the below error message in standard NAV 2018 (Version 11.0.27.667) when I reversed a payment in page Customer Ledger Entry that there is realized Gain Loss. <You can not reverse Cust. Ledger Entry No. 2844 because the entry has an associated Realized Gain/Loss entry.> Further debug showing…
-
How to get the Average Unit Cost of an item back to ZERO?
Hi, I have a situation which maybe you can help me with: Costing Method: Average In 2011, the user did created this item card and did a purchase of 2 units with a cost of EUR 120.00. In 2018 these items were still present in their stock and they decided to keep track of them and leave them in their stock but at 0 cost, so…
-
Assign Charge(Item) to Multiple Receipts
I have a scenario, where I purchase goods and the same is kept at a third party godown. Based on my requirement I release the goods from the third party godown and receive them in my godown. Thus my actual receipts are not in for the entire goods but in tranches. I also purchase freight service which is defined as…
-
What Table Data Permissions are required in NAV 2016 using the Electronic AP Payment.
Looking for the Table "Read" Permission required to create the individual PDF Remittance Advice files
-
deleted posted bank reconciliation
hello, I deleted a posted bank reconciliation.. what can i do to fix it?
-
Error while reversing cust ledger entry
Hi . I am getting below error while trying to reverse customer ledger entries kindly assist. ''you cannot reverse cust.ledger entry no..because the entry is either applied to an entry or has been changed by a batch job''
-
How to Reverse a Posted GST Settlement Entry (in NAV 2016)
Hi, I am trying to reverse a posted GST Settlement entry which was posted with some mistakes but now I want to rectify this. Is there any solution? So that I can reverse it manually.
-
budget entries
is it possible that i have more budget entries than gl entries? and if so.. could anyone tell me whether this is okay or not? do you have it and why?
-
budgets in NAV
hey people. I've got a question in regards of budgets. So i have created a budget in the Budgets section. BUT woould it show me the same numbers if I went to the Chart of accounts and filter it on the Budget filter? What is the difference?
-
Purchase Order invoice - adding VAT?
I've came across a situation where the vendor was initially setup to be paid in Euro and 0% VAT. However arrangements have changed and the vendor will be paid in GBP with VAT added. The issue is that there is an existing PO with receipts in Euro + 0% VAT. I've tried raising a Purchase Invoice, change currency code to Euro…
-
analisys by dimension
hi! i want to use g/l balance by dimension, BUT by subdimension. is there something i can use?
-
Analysis View/Account Schedule
hey nav people, can somebody explain to me please what is the difference between these two? also when are you using account schedule and when analysis view.TIA
-
cancel ach
how can I cancel an ach?
-
Partial revaluation is not being considering when using revaluation journal
Hi, Does anyone knows why partial revaluation is not being considered in the averange cost calculation? I have an item which was previously revaluated, I can see in the Value Entries that the field partial revaluation is True. When I add this item in the revaluation journal and use the function "calculate inventory value",…
-
Sales Quote print isn't working
When I do the print from the sales quote card, there is an error occurred. The Statement report does not have a DataItem that uses the table (Table 36 Sales Header) specified in the function SetTableView. In other company instance, it is working. I created a new company, it also working there. But, in the current…
-
unit cost adjustment in Business central
Hey, is it possible to adjust Unit Cost on items, that has type of Non-inventory or service? we have a customer that cannot do it, when item ledger entry has been created.
-
Error is coming while doing payment electronic
Kindly share setups for SEPA Direct debit. Thanks & Regards, Aman deep Singh
-
Reg: TDS on Advance payment
Hi everyone, I am facing an issue while making an advance payment towards vendors, in a bank payment voucher while clicking a drop-down in the TDS nature of deduction I am not getting NOD nature against which TDS needs to be calculated, Kindly help me out with this issue.
-
I've started Change Global Dimension and it takes too long. Can I stop this job without damages?
I've started Change Global Dimension and it takes too long. Can I stop this job without damaging the database, and if yes then how?