Localization features (Serbia) - NPSBeograd/NPS-Support GitHub Wiki
Welcome to Microsoft Dynamics 365 Business Central
Microsoft Dynamics 365 Business Central (BC) is the successor to Microsoft Dynamics NAV (NAV). Base code (this is the layer of which is shipped from Microsoft) is the same for both products. The difference is how customization is handled. As NAV partner we made changes directly to the Base code and ship in a database to our clients. Each new update for Microsoft is a painful upgrade process. BC handles added code in a different way with a focus to be fully upgrade-able each time. It comes with a lot of limitations. It's a challenge both for Microsoft and partners to overcome those limitations and will eventually put aside the painful upgrade process.
On top of the Base Code, we have delivered different extensions. It covers application translations and functionalities that are useful when using Business Central. Help for additional features is described separately.
๐ถ Overview
๐น How to import Localization package
To become acquainted with our Localization, you should perform a package import. This will allow you to receive specific data based on the package you choose to import. For importing a package for Localization, you can choose from three types of packages, depending on your company's needs. Further details are elaborated in the subsequent text.
NOTE: To avoid replacing your settings within your production environment, it is advisable to use an empty environment or sandbox for package imports. This precautionary measure is due to the fact that the imported package contains data that could potentially substitute your own data and configurations.
The process of importing a package is straightforward and involves just a few simple steps. You can import the package using the function accessible through a search in the assisted setup. The instructions below will guide you through the essential steps.
- When you're on the Assisted Setup page, select the package.
- Accept warning and next.
- Select type of data (Setup Date Only, Complete Sample Data), and next.
Setup Date Only - It only includes data with the settings. By choosing this package, you can perform service and expense postings. It includes batch number series and a chart of accounts. You will need to manually create customer and vendor card within your BC.
Sample Data - It includes data with the settings and data ready for posting (number series, created customers cards, vendor cards, items, fixed asset, chart of accounts, VAT, etc...)
Complete Sample Data - It includes data with the settings and data for created customers cards, vendor cards, item, fixed asset, chart of accounts, VAT, posted inventory and documents. Within the General Ledger, you will find recorded transactions, as this package contains them.
- Download package
- It asks the question only the first time you download the package. - Allow Always
- Apply Package and next.
- Finish
The package will be ready in a matter of minutes, allowing you to resume your work in Business Central.
When you've finished following all the steps to import the package, an additional tuning is required under Company Information โ User Experience โ Premium, as shown in the image. Enter Company Information into the search.
Help Assumes Premium Experience- All the features mentioned in the user documentation for Business Central are designed with the assumption of the Premium experience, implying that these features encompass the entire range of User Experience elements.
๐น NBS - NBS web service integration
This extension provides connection to National bank of Serbia service, in purpose of downloading and updating the following information:
1. Partners data (customers and vendors)
2. NBS currency exchange list
3. Local banks list
4. Industrial activities
5. Territory regions/countries
6. Customer/vendor bank accounts update
Feature | Description | Release |
---|---|---|
Service setup | The first steps of adjustment are explained below | |
How to use | In further steps, you will be instructed how to use and adjust it | |
Import data from NBS | Fast way to enter data |
๐น EPE - Banking and Electronic Payment
This functionality is created to help in keeping records of transactions of electronic payments, cash balance and bank account balances.
Feature | Description | Release |
---|---|---|
Set up bank accounts | This functionality requires the creation of a No. Series | |
Payments suggestions | This functionality calls for vendor or employees open entries to make payment suggestions and import payment journal lines | |
Payment import and export files | It is set up to export payment journal lines through the file that is further imported throughout banking application; the same programming serves to import bank statement file in program and post payments and withdrawals | |
Sales & Receivables Setup | The standard code for the reference credit formula will be defined there |
๐น INS - Instalment on Sales and Purchase
This functionality has been developed as a result of the need for document archiving with different dates of arrival. How to set up Instalment: Setting changes are performed in the Payment Terms table. In search type Payment Terms. A new term of payment needs to be created, enter the code in the tab and select in the field Type -Installments. After which a new Action called Installment calculator is initiated, in which you populate the number of installments and period length. In the field length of the period enter duration of periods. For example: one month - 1M, one year - 1Y, needs to be entered.
How to use Instalments:
This functionality is used in the same manner for both sale and purchase. After entering all the necessary data, in the header and lines of the document in the Invoicing tab, you need to select the code for the payment terms code that we have created earlier. If is necessary you can change the number of installments, level of installments or the due date in the document by clicking on the statistic; in the Installments tab it is possible to make any required changes before posting document. After posting, the same number of customer-vendor entries is being created as per the number of installments, with different due dates.
๐น CCV - Contact Customer Vendor same No
This functionality was developed due to the need that when creating a Customer/Vendor from a contact card (existing or newly created), the number series does not increase, that is, that the same number series is used for both the contact and the Customer/Vendor created from that contact, and vice versa, when a Customer/Vendor has created first, the Contact will be created automatically (or through processing Create contacts and will have the same number series as the previously created Customer/Vendor. This refinement enables the need to record the relationship with one business partner as a Customer/Vendor, and also enables an overview of the Balance (outstanding liabilities) of the Customer as a Vendor and vice versa.
Setup
New Vendors can be created in two ways:
New Customers can be created in two ways:
When entering a contact, it is possible to enter additional information, e.g. economic sector of business, type of business relationship, mail groups, addresses. If the Customer/Vendor is created from the contact card, all data that already exists on the contact will be transferred to the Customer/Vendor card, and vice versa, if the contact is created from the Customer/Vendor card, all data that exists on the Customer/Vendor will be transferred to the contact.
In order to be able to create a new vendor/customer/contact same No, it is necessary to enter the keyword Marketing settings in the quick search, then on the Numbering tab mark the fields Vendor same No. and Customer same No.
It is necessary to set the number series in the field Vendor Nos. This is done from the Purchases & Payables Setup page.
It is necessary to set the number series in the field Customer Nos. This is done from the Sales & Receivables Setup page.
๐น PRA - Payables Receivables Accounts
The functionality will not allow apply entries two different posting groups.
- The Customer Posting Group is added to Detailed Customer Ledger Entries.
- The Vendor Posting Group is added to Detailed Vendor Ledger Entries.
Filtering by posting group is enabled on the following reports:
๐น PHI - Physical inventory posting
This functionality secures possibility to check for inventories on hand and compare them with real inventories count, with the purpose of posting discovered surplus or shortage.
Also, it provides possibility to reclassify items, regarding changing items dimension, location code, serial no., lot no. or variant.
In this section:
Feature | Description | Release |
---|---|---|
Physical inventory orders | Inventories can be counted multiple times for one order/location, for example when item groups need to be assigned to different employees. | |
Item reclassification | Items reclassification, change of dimensions, tracking codes, variants or location codes | |
Physical inventory posting | Physical inventories calculation and comparison to items on hand, posting of surpluses or shortages |
๐น DPO - Document-Printout
Every company needs efficient tools to keep track on its assets and obligations and have simple and fast ways to gain those information.
Our reporting functionality provides you with such tools and simplifies your everyday analyzing processes.
In this section:
Feature | Description | Differences from standard reports |
---|---|---|
Sales - Quote | ||
Sales - Invoice | ||
Sales - Credit Memo | ||
Sales - Shipment | ||
Sales Pro Forma Invoice | ||
Purchase - Credit Memo | ||
Purchase - Receipt | ||
Service - Invoice | ||
Service - Credit Memo | ||
Service - Shipment | ||
Warehouse Posted Shipment | ||
Warehouse Posted Receipt | ||
Internal Invoice |
Set up NPS Report
A wizard NPS Report Selection Setup Wizard has been created that asks if the user wants to use localization reports or standard documents.
After you accept warning and privacy notice you are able to step forward on selecting the right package for you.
There are three options:
- Empty,
- Standard Report - use standard document prints,
- Localization Report - use localization document prints
After you select desired package data click on Download package first, then after it is downloaded check Apply Package option and then you are ready to proceed forward, click Next.
That's it! You have required data. Depending on what the user chooses in the background, the corresponding package will be imported automatically. After you click Finish the package will be applied to your company.
Substitute Document Report The following standard reports have been replaced in the Localization Report package:
Standard Report ID | Standard Report Name | New Report ID | New Report Name |
---|---|---|---|
1304 | Standard Sales - Quote | 49021061 | NPS Standard Sales - Quote |
1306 | Standard Sales - Invoice | 49021041 | NPS Standard Sales - Invoice |
1307 | Standard Sales - Credit Memo | 49021046 | NPS Sales - Credit Memo |
208 | Sales - Shipment | 49021045 | NPS Sales - Shipment |
1302 | Standard Sales - Pro Forma Inv | 49021053 | NPS Sales - Pro Forma Invoice |
407 | Purchase - Credit Memo | 49021054 | NPS Purchase - Credit Memo |
408 | Purchase - Receipt | 49021050 | NPS Purchase - Receipt |
5911 | Service - Invoice | 49021048 | NPS Service - Invoice |
5912 | Service - Credit Memo | 49021055 | NPS Service - Credit Memo |
5913 | Service - Shipment | 49021056 | NPS Service - Shipment |
7309 | Whse. - Posted Shipment | 49021049 | NPS Whse. - Posted Shipment |
7308 | Whse. - Posted Receipt | 49021059 | NPS Whse. - Posted Receipt |
5704 | Transfer Shipment | 49021086 | NPS Transfer Shipment |
5705 | Transfer Receipt | 49021087 | NPS Transfer Receipt |
5875 | Phys. Invt. Order Diff. List | 49021070 | NPS Phys. Invt. Ord. Diff. Ls. |
5878 | Phys. Invt. Recording | 49021065 | NPS Phys. Invt. Recording |
๐น REP - Reporting
Every company needs efficient tools to keep track on its assets and obligations and have simple and fast ways to gain those information.
Our reporting functionality provides you with such tools and simplifies your everyday analyzing processes.
In this section:
Feature | Description | Differences from standard reports |
---|---|---|
Customer - IOP | Customer - IOP is a report that shows customer's invoices that are partially paid or not paid. | |
Vendor - IOP | Vendor - IOP is a report that shows vendor's invoices that are partially paid or not paid. | |
Purchase Price Calculation | The purchase calculation shows the item charge costs associated with that receipt as well as the unit cost. | |
NPS Inventory - Transaction Detail | This report shows the value and quantity changes in the condition of items by locations and document numbers. | Added columns |
Stock List | Stock list is a report that shows the availability of items by location in the quantity expressed in their units of measure. | |
NPS Customer - Detail Trial Balance | This report enlists all transactions by document type and date, providing possibility to check and analyse amounts in both local and foreign currencies. | Customer posting group filter |
NPS Customer - Summary Aging Simp | This report shows the amounts due by period, for the selected customer during the selected period. | Customer posting group filter, extended customers balances due up to over 360 days |
NPS Customer - Sales list | Valuable report when it comes to getting fast information about sales in one place. | Customer posting group filter |
NPS Customer Balance to Date | This report helps to inquire information about balance per customer on the specific date. It shows all customers that have open balance. | Customer posting group filter |
NPS Customer - Trial Balance | It shows changes in receivables balances over a certain time period, both on credit and debit side, with possibility to filter by customer posting groups. | Customer posting group filter |
NPS Vendor - Balance to Date | This report helps to inquire information about balance per vendor on the specific date. It shows all vendors that have open balance. | Vendor posting group filter |
NPS Vendor - Detail Trial Balance | This report enlists all transactions by document type and date, with possibility to check amounts in two currencies. | Vendor posting group filter |
NPS Vendor - Purchase List | The report pays attention to all the purchases within a certain time period | Vendor posting group filter |
NPS Vendor - Trial Balance | This report helps to inquire information about balance per vendor on the specific date. It shows all vendors that have open balance. | Vendor posting group filter |
NPS Vendor - Summary Aging Simp | This report shows the amounts due by period, for the selected vendor during the selected period. | Vendor posting group filter, extended vendors balances due up to over 360 days |
NPS Trial Balance With Start Balance | This report shows Credit and Debit Balance, Net Charge and Net Charge Balance for each G/L Account, group and class of G/L Accounts on the specific date. | Added options and columns |
Vendor - Detail Trial Bal. in Curr. and LVT | This report enlists all transactions by document type and date, providing possibility to check and analyse amounts in both local and foreign currencies. | |
Customer - Detail Trial Bal. in Curr. and LVT | This report enlists all transactions by document type and date, providing possibility to check and analyse amounts in both local and foreign currencies. | |
Commitment Analysis Summary | This report shows the analysis of Customers, Vendors, Bank Accounts, Employees, Fixed Assets distributed by G/L accounts. The report presents the following data: starting balance, debit amount, credit amount, not due and overdue amounts. | |
Commitment Analysis | This report shows the analysis of Customers, Vendors, Bank Accounts, Employees, Fixed Assets distributed by G/L accounts. The report presents the following data: debit amount, credit amount, remaining amount and balance by document numbers. |
๐น FAM - Fixed Assets Management
The following topics provide more information on how to use Fixed asset advanced functionality, to post, change and analyse detailed data on fixed assets through Business central.
In this section:
Feature | Description | Release |
---|---|---|
FA history | Information on changes regarding tracking assignment/discharge of fixed assets by location, employee or customer. It also provides valuable report for review or print out and verification | |
FA preparation posting type | It serves to companies needs to keep track on fixed assets that are purchased but not yet in use | |
FA details | Detailed information source on fixed assets posted transactions and changes | |
Set up depreciation on FA classes and subclasses | It makes it easier to fill in all necessary information regarding depreciation by only choosing the right class/subclass, instead of filling out each FA detail card separately |
๐น NIA - Negative Inventory Adjustment Allowance
Negative Inventory Adjustment Allowance
NIA provides that any negative Item Quantity can not be posted on posting date, except in case if on Item Card is set differently (Option โNoโ on Prevent Negative Inventory on Inventory Tab). This practically means that if a certain Item is on stock today but yesterday was not, the program shows an error when you try to post on that date when that Item was not on stock.
Inventory Setup
Before posting any Item Ledger Entries there should be a setup which defines how to control negative inventory posting.
- Open Inventory Setup.
- Set field Prevent Negative Inventory on General Tab to enable standard functionality to prevent negative inventory.
Item Card
- Open Item Card.
- Choose Prevent Negative Inventory on Inventory Tab from options:
- Default (Yes): option is used if you want always to prevent negative posting on the Item.
- Yes: option is used if you want always to prevent negative posting on the Item.
- No: option is used if you don't want to prevent negative posting on the Item.
Post Sales Order
Sales Order is used to post items to customers. When posting Sales Order program checks if there is any inventory for Item, on a certain location and on posting date.
- Open Sales Order and create a new document.
- Enter Customer No. and all other mandatory data.
- Choose Item No.
- Choose Location Code and other mandatory data
- Post Sales Order by choosing Posting->Post
The program shows error and prevents the negative posting of Item on Location in case there is no Inventory on Location on specified posting date.
Post Sales Invoice
Sales Invoice is used to post items to customers. When posting Sales Invoice program checks if there is any inventory for Item and on a certain location on specified posting date.
- Open the Sales Invoice and create a new document.
- Enter Customer No. and all other mandatory data.
- Choose Item No.
- Choose Location Code
- Post Sales Invoice by choosing Posting->Post.
The program shows error and prevents the negative posting of Item on Location in case there is no Inventory on Location on specified posting date.
Post Item Journal
Item Journal is used to post items to and from locations. When posting Item Journal program checks if there is any inventory for Item and on a certain location on posting date.
- Open Item Journal and create a new line.
- Enter Document No.
- Choose Item No.
- Choose Entry Type Negative Adjmt. or Sale.
- Choose Location Code
- Post Journal by choosing Actions->Posting->Post.
The program shows error and prevents the negative posting of Item on Location in case there is no Inventory on Location on specified posting date.
๐น DCA - Debit Credit Amounts
๐น COM - Compensation
This functionality is created for planning, contracting and posting obligations fall due by compensating Customers and Vendors, creating related document called Compensation proposal.
Pre-requisites for using this functionality is to set contacts relations between linked Customers and Vendors, which are business partners a company has payables and receivables at the same time.
There are fields, Balance(DVT) as a vendor and Balance(DVT) as a customer on vendors and customers contact cards. According to these amounts, the system recognizes total amount of payables/receivables with certain partner and can create Compensation proposal.
How to create Compensation overview:
Before Compensation proposal is created, you can find Vendors and Customers that have condition for compensation and look for the amount for compensation. This can be done through report called Customer/Vendor preview, with possibility to filter Customer/Vendor.
- Go to Search window and type Customer/Vendor preview
- Select No. of contact from Filter-Contact list, if you want overview balances for one or a few partners.
- You can Filter totals by Date filter, Salesperson filter, Sales cycle filter etc.
No. | Name | Cust.balance | Vend.balance | Difference | Possible compensation amount |
---|---|---|---|---|---|
C0050 | Dynamic trade doo | 12000 | 22000 | -10000 | 12000 |
How to create Compensation proposal:
With the list of partners eligible for compensation, next step is to create Compensation proposal. Compensation proposal can be printed as a separate report to send to business partner for confirmation.
- Go to Payment journal โ Process โ Suggest compensations. New page will open, it is necessary to set up fields for Posting date, Document number and Description. It is possible to select certain Vendor/Customer, simply enter Ven./Cust. No.
- Depending on open entries for all or a few Vendors/Customers and payables/receivables due date, the system will create journal lines. You can arrange the journal, having some lines deleted, if not desired to make a compensation for all the payment journal lines.
- You can check Applies to doc. No. and Applies to doc. Due date. These fields are editable, in case you want to choose a different invoice to apply.
- Correct amounts to be applied are related to open Customer/Vendor entries. Payment journal balance is to be 0.
- Then go to Report โ Compensation proposal to print the report in order to forward it to your business partner for confirmation.
How to post compensation:
If your business partner confirms, the final step is to post compensation journal lines from Payment journal.
New Customer/Vendor entries will occur after Payment journal is posted. As a result, original invoices are applied, having payables and receivables settled.
๐น VAT - VAT Management
VAT is a general consumption tax that is calculated and paid. The Vat in RS is 10% (general percentage) and 20% (special percentage). VAT is calculated for all taxpayers. It is calculated once in a month or once every three months. When VAT will be calculated depends on which category you are. After you finish the VAT calculation, you need to send it to the tax administration. The tax administration controls your VAT, because you will send it.
What is VAT in Business Central and how can we calculate it easily and precisely? It is the right time to find out.
For your VAT calculation to be easier to work with, you should define VAT Identifiers. The VAT Identifiers will be set on VAT Posting Setup. Documents entered and documents created in Business Central will have appropriate VAT identifiers. The VAT Identifiers will help you to define the VAT Book. All VAT books together are a VAT calculation.
Feature | Description | Release |
---|---|---|
VAT book groups | Define the lines of a VAT reporting form | |
VAT identifiers | Describes the posting of VAT Identifier when posting VAT entries for a certain combination of Posting Group | |
Postponed VAT | VAT amount is to be suspended as it is not possible to settle it at a given time. . | |
Reverse Charge VAT | It is calculated on some services from abroad. |
๐น RVE - Reverse
With this functionality, companies can use specific document called Reverse order, to assign any item to employees, customers or vendors.
It goes with an option for print out shipments and receipts of reverse transfers and also with possibility to check reverse assignment review showing active reverse orders for certain period.
In this section:
Feature | Description | Release |
---|---|---|
Reverse orders | Offers possibility for posting and efficient tracking items assigned to either employees, customers or vendors | |
Inventory reverse preview | It is a report that provides valuable information on when/to whom are items given for use |
๐น MNM - Minor assets management
Minor assets allows the transfer into use after purchasing of minor assets. When put into use, it can then be issued in reverse. To perform entries for minor inventory in use, it's necessary to set up Item Journal Template. Create a new form, and on that form, you will define:
- No. Series
- Source Code
- Subtype
The next step is to set up the Batches.
Adjust the General Posting Group and Location Code for Minor Assets in the Item Journal Batches, and finally, enter the Subtype at the bottom of the table.
General Posting Setup.
When you want to transfer minor assets into use, this is done through the Item Journal.
Select the created template from the list, as shown in the picture.
In the Item Journal, Enter Type - Negative Adjustment is entered, and Item No, Location Code, and Quantity are entered.
Item Ledger Entries Preview.
๐น DPS - Double Posting
This functionality is developed for posting transactions of class 9 โ calculation of manufacturing cost of goods sold.
It is possible to enter these changes through Double posting settings on Account card using two different ways:
- Direct double posting on account
- Double posting through dimension group values
In this section:
Feature | Description | Release |
---|---|---|
Direct double posting on account | This setting is used in case we want to directly post and create two additional class 9 entries, with each transaction posting, for the accounts pre-defined to have this ability | |
Double posting through dimension group values | Functionality used if needed to set and post double-posting transactions through group dimension values |
๐น AXR - Advanced Exchange Rates
Within this functionality, users are allowed to select a separate account for each posting group of customers/vendors, on which the realized and unrealized exchange rate differences will be posted. The need for this functionality arose from the accounting regulations which require that exchange rate differences from relations with Parent, Dependant and related legal entities be recorded in different accounts (about to accounts set in currencies).
An additional advantage that the processing includes is that the general ledger items resulting from the processing of exchange rate differences are recorded by the number of sources (number of customers/vendors).
Before working with this functionality, it is necessary to enter the NBS exchange rate on the day when the processing is done:
- In quick search find Currencies
- Select the currency for which you want to enter the exchange rate
- Choose Process->Exch. Rates and enter the currency
Adjust Exchange Rates Setup
- In a quick search, type Adjust Exchange Rates Setup
- Choose New to add a new line
- Enter posting groups, currency and corresponding accounts of realized / unrealized, gains/losses exchange rate differences
Lines on this list can be edited or deleted with the appropriate actions. Based on these settings when processing exchange rate, these combinations will be posted to the corresponding accounts.
After these settings, the Adjust Exchange Rates functionality can be started:
- In a quick search, type Adjust Exchange Rates
- Enter Starting/Ending Date for which exchange rate differences are to be calculated.
- Enter other related data
- Click OK to start the calculation and posting
๐น PGI - Inventory (Journal) Posting Groups
Items General business posting groups
This functionality allows to set gen. bus. posting group on locations that will copy to all item journal lines.
It can be done for different actions with items โ transfer, assembly order, physical inventory, opening balance, revaluation, reclassification.
I How to set gen. bus. posting group on Item journal batch
This functionality regarding inventories enhancements allows to set up gen. bus. posting groups on Item journal batches that will apply to all item journal lines.
- Find Item journal templates in Quick search engine
- Choose template for adjustments and on Navigate tab, select Journal batches
- Choose Gen. bus. posting group on Item journal batch that will be used as a default value with data in journal lines
II Assembly orders
We use assembly order to create items that are a combination of more items/resources and needed to be sold or placed in location as assembly on stock. In order to use this option, it is necessary to create an assembly item and adjust assembly setup.
How to create assembly item:
- Go to items and create a new one. Choose inventory posting group
- On Replenishment tab find Assembly section, and choose Assembly BOM โ โyesโ
- New page will open. Add lines with items/resources to form your assembly item. Here you will define item tracking lines if needed
Adjust Assembly setup
- Go to gen. business posting groups and define one for Assembly orders
- Find Assembly set up, General tab and on field Gen. bus. posting group select posting group for assembly orders that is previously created
- Numbering tab requires attention, meaning to select new no. series Assembly order nos., Posted assembly order nos. There are additional two fields for Assembly quote nos. and Blanket assembly order nos., if needed to use and adjust
Here you will find additional assembly setup options such as:
- Stockout warning: it specifies whether stock availability warning will appear during sales order entry
- Default location for orders: specifies in which location assembly order are created by default
- Copy component dimensions from: specifies if dimension is to be copied from item/resource card or Order header
How to create and post Assembly order for stock
- Find Assembly orders and create New
- Choose item assembly and quantity
- Enter items in Assembly order lines
- Check Posting tab, it should have pre-defined gen. business posting group for Assemblies
- Post assembly order. Ledger entries for items/resources spent will show as Assembly consumption entry types, created assembly as Assembly output
How to create assembly order within the Sales order
You can create assembly order within Sales order document. Prior to this it is only necessary to have item defined as assembly, as shown in one of the previous sections.
- Open new sales order
- Fill in standard General tab fields
- In Sales order lines, choose your assembly item and go to column Quantity to assembly to order. Fill in with the number of quantity and then on drill down to record, new page will open. On the page, define item/resource lines to compose this assembly order
- By posting the sales order, in the background, assembly order is created and posted; to check this, go to posted assembly orders, or check item ledger entries
- Item ledger entries will be posted with Assembly gen. bus. Posting group, as defined in Assembly setup
III Transfer orders
Gen. bus. Posting group is to be created for transfer orders. It can be set up on Location card.
- Go to Location. Create In-transit location and setup field Gen. bus. Posting group for โtransfersโ
- Go to Transfer routes and define Transfer routes matrix
- Set gen. business group for transfers in items journal batch for this activity
How to create and post Transfer orders
- Search for transfer orders and create a new order
- Set header fields โ Transfer from, transfer to location
- In-transit code should automatically appear, according to previously adjusted transfer routes
- With previous steps, field Gen. bus. Posting group will automatically fill in, since it is modified within the location for transfer
- Fill in Transfer order lines, post the shipment and receipt. Two documents will be created: Transfer order shipment and Transfer order receipt
- Item ledger entries will be posted with Transfer gen. bus. posting group, as defined in header of the transfer order document
๐น DCT - Document Subtypes
Document subtypes provide possibility to post different types of transactions regardless of current settings on items, customers and vendors.
If any specific situation requires to set up new posting scheme (specific combination of posting groups and new G/L accounts), it can be achieved through this extension.
Companies can create document subtype for each business transaction, having at the same time a benefit of classifying transactions, sorting out and further use in internal analyses.
How to set up document subtypes:
There are Sales document subtypes and Purchase document subtypes. Instructions go for both Purchase and Sales documents, with remarks to eventual differences.
Go to search and type Sales document subtypes or Purchase document subtypes.
Click on New and set some of the standard fields:
-
Document code โ short code for the document type you want to create
-
Document description โ further details, description on your new document type
-
General business posting group โ in most of the cases it will be more convenient to create new gen. buss. post. group in order to set up new posting scheme
-
VAT business posting group โ create a new one if existing are not eligible to make combination
-
Vendor/Customer posting groups โ this option exists if there is a need to change vendor or customer posting group for the purpose of specific posting scheme
-
Payment method โ used to define payment method for our document type, it can be chosen as type of balance account (G/L account or Bank account)
-
Check if it is for Internal correction โ for Credit notes and Return orders
-
Document type โ it can be a choice between existing document types: offer, order, invoice, credit note, return order, blanket order.
This setting will affect on visibility within different document types. For instance, if our document subtype is for sales invoice, it will not be offered for selection in any other sales document.
- Posting number series โ serves to create new posting no. series for your document type
- Receiving number series โ if necessary, to define new receiving no. series
- Vendor/Customer name โ all can be set up only for a certain customer/vendor
How to use document subtypes
Document subtypes can be created and used in various transactions such as:
- Sales/Purchase return
- Sales/Purchase prepayment
- Sales return for sales from the previous fiscal year
- Debit and credit notes
- Payment discounts and sales/purchase discounts
- Different expenses, such as gifts given to customers for presentation of products etc
Note: It is necessary to add relation between new posting no. series and no. series of the standard posting document type. For instance, if we want to create new sales invoice document subtype, and our new no. series is PNS and our standard no. series for sales invoice is PKF, we need to manage relation between those two.
This can be done through No. series administration โ find your standard posting sales invoice no. series โ go to Navigate โ Relationships. Add new no. series code to relate to this standard one.
Feature | Description | Release |
---|---|---|
Purchase document subtype | New purchase document subtype for returned goods may require updated VAT settings per specific regulations. | |
Sales document subtype | New sales doc subtype for testing new machine with used items |
๐น PPE - Prepayment
Prepayment functionality enables posting of prepayments and preparing related prepayment documents according to local regulations VAT requirements.
Therefore, this feature requires and correlates with certain VAT functionality extension options.
The rule says that Prepayment sales invoice must be posted if prepayment was received from customers and items were not shipped in a period that prepayment was received. Respectively, prepayment purchase invoice is received from a vendor in case that company has paid for items that were not received within the same period when the prepayment was.
In this section:
Feature | Description | Release |
---|---|---|
Sales prepayments | Shows settings and functionality of sales prepayment posting, prepayment invoices and final invoice for items or services | |
Purchase prepayments | Shows prepayment functionality regarding purchasing activities | |
Prepayment credit memo | Information on how to reverse posted prepayment invoice |
๐น ICA - Item Charge Assignment
Item Charge Assignment ICA is used to order certain items, dependent costs allocated according to certain criteria to those items.
The program can save the charge of the articles, e.g. transport or packaging - which can be added to ordered items.
Using this functionality, the cost of product purchase can be directly determined and analyzed.
By adding item charge (dependent purchase costs) to the order, costs can be allocated directly to the items.
Item Charge Assignment by Tariff Number
If a charge by Tariff number is used, the Tariff number must be defined.
- In the quick search, type Tariff Numbers and there you can enter the tariff numbers to be used:
No. | Description | Rate % |
---|---|---|
0210.19 | Komadi pileฤeg mesa | 1,5 |
- After defining the tariff numbers, on the Item card enter the appropriate Tariff number for that item on the Cost & Posting tab.
On order/Invoice: Add a new shipping cost line for the newly created Order / Invoice.
- Select the option Charge (Item) in the field Type.
- Select in the field No. some Item charge
- Enter 1 in the field Quantity.
- Enter the Unit cost as well.
- Click the button Line->Related Information->Item Charge Assignment. Run the Item Charge->Suggest Item Charge Assignment by Tariff Number.
After that, the costs will be distributed among the items.
After selecting the close button, a window will appear asking "Purchase Line has multiple item charge assignments. Do you want to split line per assigned item charge?" If you select "Yes", the program will split the cost into as many lines as there are items with a tariff no with the corresponding amount, if you select "No" the cost will be in one line with the amount in full.
Breaking of dependent costs by dimensions When we have several items with different dimensions on one purchase order/invoice and need to be assigned dependent costs, functionality has been developed that automatically creates separate items for each dimension combination ID when posting dependent cost related to multiple receivers or delivery.
๐น CSD - Cash Desk
Cash Desk operations include taking, keeping and issuing cash. Transactions cash in one company are done through the cash register . This functionality was developed due to the need to record cash transactions. Cash registers are based on the possibility of posting payment journals.
Feature | Description | Release |
---|---|---|
Cash desk settings | Description of important steps to follow for completion of functionality setup | |
Cash Receipt List | It is the process of opening journal in order to make the posting | |
Cash Withdrawal List | It is the process of closing journal in order to make the posting | |
Correction Select Lines and Reverse | It is the process of correction select lines or cash order reverse | |
Closed and Post Cash Report | It is the process closed and posting cash report |
๐น IFR - Item - FA Reclassification
This functionality was developed due to the need to record transactions related to fixed assets and items. Functionality was developed due to the need to put a certain item into use as fixed asset and that the system maintains the connection of these transactions through adjustment item cost job.
How to set up Reclassification: The path is as follows:
- Type in search Item FA Reclass. Setup
Setup is done in table Reclass items to FA setup. It`s required to set No. series for documents, as well as posting groups, fixed assets posting type and balance account number for item and fixed asset. After that itโs required to enter source code for Reclass from FA to Item and vice versa.
How to use Reclassification:
Feature | Description |
---|---|
Item to FA Reclassification | How to use Item to FA Reclassification |
FA to Item Reclassification | How to use FA to Item Reclassification |
๐น DIM - Dimension Management
Modify dimensions on posted entries If some dimension on a document has been posted mistakenly, this functionality enables changing posted dimensions on posted entries.
- Go to General Ledger Entries and search entry that should be changed.
- Choose Actions->Modify dimensions
- Enter the new dimension
- Press OK button to apply entered changes
Now on that G/L entry there must be a new dimension which was entered.
Note: If G/L entry, which is modified, has an account schedule (costumer/vendor entries, Fixed Assets entries, etc), modified dimension will be registered on that entries automatically.
๐น YEP - Yea-End Process
All No. Series that we have created and that we use for easier tracking of all business changes and processes should be reopened for the next year.
Feature | Description | Release |
---|---|---|
Create No. Series Line | When opening a new business year in BC, a new No. Series must be created that will be used for the following year. |
๐ถ NBS web service integration
๐น Service setup
There are pre-conditions for this extension to be activated.
- Company's membership in National bank of Serbia web system
- Installation of digital certificate
Find from the menu or search for Setup&Extensions, Service connections/NBS Setup.
Click on NBS Setup, then Setup.
Enter NBS user name, NBS password, NBS licence ID. The rest will be automatically filled in by clicking on Set URLs to default.
Click on "Test connection" action.
If needed, check "Block customer if bank is blocked" and/or "Block vendor is bank is blocked".
๐น How to use
Below is the list of all available actions included within this functionality.
Local banks
This action will import all the information about state registered banks - name, address, contact info, homepage.
Currencies
This action provide complete exchange currency list.
It also provides NBS exchange rates import - through daily job, or action when needed. Daily jobs settings are placed within Job queue entry, where parameters can be edited if necessary.
Activities
Provides info of designated industry groups.
Territory regions
Updates information about state regions:
Countries
It downloads countries database.
Partner data
This action can be called through customers/vendors cards:
It updates partner's data information - name, address, region, registration date, activity ...It is necessary to have Registration no. recorded on Customer/Vendor card in order for this action to work. It can also help to create new contact - by adding only registration no., the rest of data will be inserted.
It also serves to link industry activity to contacts and can be used further for marketing segmentation for different industry activities. New contact can be also created from the Contact list:
New window will open, to type either Registration no, or VAT registration no.
With confirmation, company data will show, and with confirmation, new contact is created.
Customer/Vendor bank accounts
It is enabled to insert and update partner's bank accounts. This action can be initiated for all customers and vendors, or for particular ones, through customer/vendor cards. It works only if VAT registration number is familiar.
Daily jobs for currencies and bank list update
It is possible to set up daily jobs, actions that will occur on daily basis, on the exact time, to update the last published exchange currency list and bank list.
๐น Import data from NBS
Importing a list of contacts could be done by invoking these two actions:
-
Download Excel template
-
Customer/Vendor from Excel
1.Download Excel template - Excel contains all important data for creating a contact card (customer and vendor)
The following fields should be filled in:
- VAT Registration No.
- Registration No.
- Customer Templates
- Vendor Templates
- Old customer No - if you transfer data from the previous software
- Old customer name if you transfer data from the previous software
- Old vendor No - if you transfer data from previous software
- Old vendor name - if you transfer data from the previous software
Mandatory fields that need to be filled in are VAT Registration No. or Registration No., Customer Templates and Vendor Templates. If there isn't such data, contact, customer and vendor won't be created . Other fields from the table should be filled in if you need that data.
2.Customer/Vendor from Excel - Invoking this action the data will be imported from Excel
On the request page button choose will allow us to select the excel document that we want to import. If any vat registration number is not correct, you will receive error message.
๐ถ EPE - Banking and Electronic Payment
๐น Set up bank accounts
The first setting when creating a bank account is the number series. Entering the search bar No. Series.
After that enter in the search Electronic Payment menu. Action New will open a new bank card.
How to set up bank accounts
It is necessary to set up bank accounts โ posting groups, currency, account number, no. series, source codes. For each bank you can set up General journal template, defining type โ Electronic payment, Bal. Account type โ Bank account, No. series, and Source code.
You can set up General journal batches for each bank:
- Copy VAT setup to journal lines (whether the program calculates VAT for accounts and balancing accounts on the journal lines of the selected journal batch)
- Insert XML data ports requires to complete setup, depending on bank client, both for file imports and exports
No series and XMPL port need to be entered on General Journal Batch.
๐น Payment suggestions
How to create vendors payment suggestion
Go to Electronic payment menu. Select bank you want to work with. Next step is to choose Preparation - El. payment journal will open. Choose option Prepare/Suggest vendor payments. In new window, define important filters:
- Last payment date: Last invoice date that will be included in payment suggestions; all entries before that date and on the date will be included
- Use vendor priority: if there are limited payment funds, type in Available amount LCY and along with this filed the system will suggest lines by priority until this limit is entirely used
- Posting date
- Summarize per vendor: activate this option if all vendor entries need to show as summarized in one line
- New doc. no. per line - type manually if no. series are not set up If there are already suggested lines in other journal batch, the system will show warning, escaping the possibility to have duplicated payments:
Vendor payments confirmation
Next step is to select and confirm lines for payment. If all the lines need to be selected, choose Related/Payments/Confirmation:
Payment lines will be found in Confirmation at the Electronic payment menu:
How to create employee payment suggestion
Similar to Vendor payment suggestion, go to Electronic payment menu, choose Preparation :
-
Suggest Vendor Payments.
-
Suggest Employee Payments.
Next thing to fill in is the request page
๐น Payment import and export files
How to export payment journal lines file
After the payment lines for vendors and/or employees are confirmed, these can be exported as txt. file, ready for import within the electronic payment app.
To export this file, go to Confirmation/Related/Payments/E-Payment export:
How to import bank statement
From Electronic payment menu select Statement:
Next, go to Related/Payments/E-payment import
New window will appear, choose file for import (previously exported from el. payment app). During importing process, the system searches for customers/vendors by bank account. If there is no bank account on customer/vendor card, there will be a notification warning.
Even though some customer/vendors have not been found, all the transaction will be imported. Depending on side (Debit/Credit), the system will choose Account type (Vendor or Customer) leaving account no. empty if those lines have not been found.
If payment needs to post as prepayment, there is a filed Prepayment that has to be checked.
Vendor and customer ledger entries that are found by credit reference no. will be selected for application in "Applies to doc. no". If desired, further entries application can be completed through this journal.
After regular control of the statement, it can be posted through "Post" action on header.
๐น Sales & Receivables Setup
On the Sales & Receivables Setup page there is a field Def. Credit Ref. Formula Code. The field is adjusted and the formula is defined for further recognition. The field will be filled in on sales invoices and on posted sales invoices.
To create a code, choose select from full list.
- Code name is entered
- Enter the description for the code
- Model - it can be filled in, it is not a mandatory field
- Formula - gives us a list where we can choose parameters
- The maximum number of parameters allowed to be selected
Sales invoices - Invoice Detailes
Posted sales invoice - Invoice Detailes
The Credit Reference No field will also be filled in on the statement. When importing txt format.
๐ถ CCV - Contact Customer Vendor same No
๐น Create Contacts from Customers
This processing should be started if the Customer was first created from the Customer table and the Customer/Vendor same No. setting was not active (if the setting is active, the contact would be created automatically). So, the Customer (which was entered before the setting) should also be in the contact list. To ensure this, it is necessary to make the previously described settings, and then start processing:
- In the quick search type: Create Contact from Customer
- Enter the required Customer filters on the form
- OK
Contact with the same number as the Customer is now in the contact list.
๐น Create Contacts from Vendors
This processing should be started if the Vendor was first created from the Vendor table and the Customer/Vendor same No. setting was not active (if the setting is active, the contact would be created automatically). So, the Vendor (which was entered before the setting) should also be in the contact list. To ensure this, it is necessary to make the previously described settings, and then start processing:
- In the quick search type: Create Contact from Vendors
- Enter the required Vendor filters on the form
- OK
Contact with the same number as the Vendor is now in the contact list.
๐น Creating a Customer from a Contact card
Setup In order to use this functionality, it is first necessary to define the Number series:
- In a quick search type Sales and Receivables Setup
- On the tab Number Series, define the Customer Nos
Hint: Number series for Customers can be the same as for Contacts, or they can be different, in which case if a Customer is created first, Contact with the same Number series as the Customer will be created automatically. Check link
Creating
- Go to Contacts
- Click New, or find an already created contact
- Fill in the required fields (No., Name, Adress...)
- Go to Actions-> Functions->Create as->Customer
- Choose the appropriate Customer template
Check the Customers list, there should be a Customer with the same number and data as the contact and with the settings as the selected template.
๐น Creating a Vendor from a Contact card
โช๏ธ Setup
In order to use this functionality, it is first necessary to define the Number series:
- In a quick search type Purchase and Payables Setup
- On the tab Number Series, define the Vendor Nos
Hint: __Number series for Vendors can be the same as for Contacts, or they can be different, in which case if a Vendor is created first, Contact with the same Number series as the Vendor will be created automatically. Check link
โช๏ธ Creating
- Go to Contacts
- Click New, or find an already created contact
- Fill in the required fields (No., Name, Adress...)
- Go to Actions-> Functions->Create as->Vendor
- Choose the appropriate Vendor template
Check the Vendors list, there should be a Vendor with the same number and data as the contact and with the settings as the selected.
๐น Customer Vendor-templates
Customer/Vendor templates are used to map the data from the contact to the Customer/Vendor. The Customer/Vendor card gets some more features that are defined for the group of Customer/Vendor on the template card, e.g. posting groups, country codes, territories, payments... These are additional data, which the contact does not have, and which greatly affect the transactions that will be performed later with the Customer/Vendor.
โช๏ธ Setup
Typically, the system offers templates that are created on Contact Conversion Templates only when creating a customer from a contact card. In order to be able to use appropriate templates for both Customers and Vendors, it is necessary to enable this functionality first. In the quick search, type Feature Management, in the newly opened window it is necessary to enable the option Feature Update: Conversion templates to convert contacts to vendors and employees
โช๏ธ Vendor templates
Setup
- In the quick search type Vendor templates
- Choose New
- On the General tab enter Code, Description, Contact Type
- On the Invoicing tab enter appropriate posting details (such as Gen.Bus.Posting Group, VAT Bus. Posting Group, Customer Posting Group)
- On the Payments tab enter the payment settings.
โช๏ธ Customer templates
Setup
-
In the quick search type _Customer templates
-
Choose New
- On the General tab enter Code, Description, Contact Type
- On the Invoicing tab enter appropriate posting details (such as Gen.Bus.Posting Group, VAT Bus. Posting Group, Customer Posting Group), Prices and Discounts
- On the Payments tab enter the payment settings.
๐ถ PHI - Physical inventory posting
๐น Physical inventory order
This functionality provides possibility to do physical inventories, besides Physical inventories journal.
Its benefit lies in the fact to have additional option to organize whole process according to rule, one location, one physical inventory order. Counting goes for one order and one location.
Inventories can be counted multiple times for one order/location, for example when item groups need to be assigned to different employees.
The steps go as it follows:
- Physical inventories order creation โ for expected quantities are filled in from system information
- Calculation inventory creation โ from phys. inventory order, one or more
- Register of counted quantity in calculation of inventories โ manual entry or importing csv file.
- Physical inventory order posting โ at the end of the process of calculating, counting and recording
Setup:
In order to use this functionality, go to Inventory setup, Numbering tab and set fields for Physical inventory orders series no. and Posted inventory no. series no.
Details on physical inventory order creation:
- In the header of this document are information about the way to complete this activity, and in lines are information on items and locations.
Document header:
- No.
- Description
- Location code
- Responsible employee
- Responsible inventory order employee
- General product posting group
- General business posting group
- Order date
- Posting date
- Dimensions
- The next step is to activate Calculate lines option from the ribbon. This option calculates recorded inventories by defined filters
It is necessary to turn on option โCalculate qty expectedโ in order for the system to suggest qty on hand. This processing will fill in physical inventory order lines with calculated quantity in column Exp.qty.
The column Use item tracking shows if there is tracking or not. For each line with tracking, information on tracking for calculated qty is displayed through option Line-Item tracking lines โ Expected item tracking lines.
Create new recordings
As mentioned, this process is to be done through order and it can be more than one, usually depending on employees no, responsible for this activity.
Inventories counting list is a document for recording physical actual inventories qty found or counted on actual locations. This document is created through option Make new recording. If we don't select/filter, it will count for all the lines from physical inventory order.
To create counting of items from the order, go to Navigate โ Order โ Recording:
Counting and recording was created for all the lines from the order. Counting shows 0 qtys as we need to enter physical qtys that we found on a certain location. If for one item needs to enter data in more lines, mark the line you want to copy and click Functions โ copy line- enter no. of copies and click ok. This will create as many lines with the same data.
On your physical inventory list, you need to fill in with phys. qty and information about serial no. or lot no., if items have tracking codes.
This list can be printed out.
After counting and recording:
Besides manual process of filling out the counted quantities, the lines can be filled in through .txt files. There is a function Export recording lines. Complete the list with recorder quantities and go to option Import recording lines. It should automatically add order lines. For those lines you have counted and recorded items, the column Recorded is going to be checked and you won't be able to import file/lines before you uncheck field.
When this completed, it is necessary to check in option Finished. There is an option Reopen, in case this document has to re-edit.
Physical inventory order posting:
When counting and recording are finished, the system connected and coupled lines from initial order with lines from the physical recording list. It is shown in order lines. On the initial order document, it is visible that recording is finished and in lines counted quantities and no. of counted (recorded) lines.
If the process is truly completed, change the status to Finished. The system will automatically calculate surpluses and shortages according to serial nos or lot nos.
You can check tracking lines for each lines separately. This order can be printed. When all done, it is needed to post the order. The result is Posted physical inventory order and its entries.
Physical inventories order entries:
In this example, we have one item with lot no. That has a surplus and shortage in other lot no. It will post positive and negative differences. Lots do have different unit price as well.
Item no. | Lot no. | Quantity exp. | Quantity recorded | Direct unit price | Unit price |
---|---|---|---|---|---|
A00029 | 12345 | 5 | 3 | 1000 | 925 |
A00029 | 101112 | 3 | 5 | 800 | 925 |
The first line should be posted as negative correction, the second line as a positive correction.
The positive correction post with average Unit price, negative corrected are valued according to item costing method - items actual cost.
Examples on physical inventory orders:
Letโs assume our item costing method is FIFO and provide some data on items in order to show value entries resulted after posting surplus or shortage of inventory with two different lots. Another assumption is that Automatic cost adjustment is set to "always". For this reason, average unit price will adjust to actual cost of item according to Cost method, each time shortage(neg. correction) is posted.
Example 1 - Surplus, one lot.no
Item ledger entry type | Item ledger qty. | Cost amount(actual) | Cost per Unit | Cost posted to G/L |
---|---|---|---|---|
Pos. adjustment | +1 | +925 | +925 | +925 |
Example 2 - Shortage, 1 piece, two lot nos.
Information on example: Quantity before ph. Inv.:
- 1st purchase, lot.1, 2 pcs, Cost: 1000
- 2st purchase lot 2: 5 pcs, Cost: 800
Value entries:
Item ledger entry type | Item ledger qty. | Cost amount(actual) | Cost per Unit | Cost posted to G/L | Entry no. |
---|---|---|---|---|---|
Neg. adjustment | -1 | -925 | -925 | -925 | 1 |
Neg. adjustment | 0 | -75 | -75 | -75 | 2 |
Posting will cause two value entries, one with item ledger entry -1 and the second entry that adds/subtracts amount in order to set it equal to Actual item cost (in this case 1000, from the fist purchase)
Example 2 โ shortage of 3 items, two lot nos.
Quantity before physical inventory order:
- 1st purchase lot.1, 1 pcs, Cost per unit 1000
- 2st purchase lot 2, 5 pcs, Cost per unit 800
Value entries:
Item ledger entry type | Item ledger qty. | Cost amount (actual) | Cost per Unit | Cost posted to G/L | Entry no. |
---|---|---|---|---|---|
Neg. adjustment | -1 | -925 | -925 | -925 | 1 |
Neg. adjustment | 0 | -75 | -75 | -75 | 2 |
Neg. adjustment | -2 | -1850 | -925 | -1850 | 3 |
Neg. adjustment | 0 | +250 | +125 | +250 | 4 |
In this scenario, two additional value entries occur to equalize the posting to the value of item actual cost (1000+800)
Example 3, shortage, serial no.
Information:
- purchase 1, serial no 123, 1000 value
- Purchase 2, Serial no 234, 800 value
Value entries:
Here we can have a situation of item shortage. As explained, this shortage values with actual item cost, the value entries would show:
Item ledger entry type | Item ledger qty. | Cost amount (actual) | Cost per Unit | Cost posted to G/L | Entry no. |
---|---|---|---|---|---|
Neg. adjustment | -1 | -900 | -900 | -900 | 1 |
Neg. adjustment | 0 | -100 | -100 | -100 | 2 |
Items reclassification
In cases there are similar items, according to accounting rules, and one is a surplus, other shortage, it is allowed to reclassify one to another.
For that matter, you can use the Assembly order. If Item 1 has a surplus and Item 2 shortage, you can "reclassify" the first item into the second one.
Choose Item 1 in the Assembly order general tab and turn on Reclassification button.
Post the assembly order. After that, re-calculate items quantity in order to get visible changes after reclassification through assembly order.
It will be necessary to re-open recording and physical inventory order status afterwards.
๐น Items reclassification journals
Item reclassification journal can be used for item characteristics changes โ variant, dimensions, guarantee expiry date, items tracking codes.
In order to use this functionality, here are the steps to follow:
- Find this journal in Quick search engine - Items reclassification journals
- Define field in Journal lines
- Posting date
- Item no.
- Location code/bin code: old codes
- New location code/new bin code: type new code
- Variant code, dimension code: old variant, dimension code
- New variant column, new dimension code column: type new variant or new dimension code
- Quantity: enter quantity for reclassification
- Applies to entry: use this field when you want to connect original entry with reclassification entry
- If you want to reclassify items with tracking, tracking information can be changed within Navigate/Lines/Item tracking lines. On item reclassification lines add information about old and new item tracking serial nos/lot nos/date
- Post reclassification journal and check items ledger entries
๐น Physical inventory posting
Physical inventories calculation and posting are done throughout Physical inventory journal. The whole process goes as described below.
Physical inventories calculation:
-
This processing activates through function Actions โ Functions โ Calculate inventory. The system automatically counts all inventories on hand based on defined processing parameters and enters data about inventories count at physical inventory journal lines.
-
New window opens, to enter data:
- Posting date
- Document no.
- Items not on inventory
- Include items without transactions: option to select "yes"
- By dimensions:
Filter: Item โ possible selection by item/items
Filter by:
- Locations filter
- Bin filter
- Click "ok", and processing will count remaining inventories, according to pre-defined criteria.
- Next step is to print Physical inventory list:
- There is a possibility to print out with or without information on calculated inventories
- There is an option to Show serial/lot number if desired
Physical inventories counting
Next step is to physically count inventories and fill in Physical inventories list by members of physical inventories commission.
- Data from Physical inventories list are then being entered on Physical inventories journal lines, in field Quantity(physical inventories). After that, the system automatically calculates and shows differences in Quantity column and changes Entry type from initial Positive correction to Negative correction, if the counted quantity is bigger than calculated.
- Depending on Entry type, next is to choose appropriate General business posting group and to post this journal lines
- For Positive corrections (on lines that have registered surplus and the lines without difference between quantity calculated through system processing and physical inventories counting quantity), enter general business posting group for SURPLUS.
- For Negative corrections, on lines with registered shortage of inventories โ enter general business posting group SHORTAGE.
NOTE: According to VAT regulation, it is necessary to post VAT inventories shortage. That is to be done through Posting journal as a separate activity to physical inventory posting.
Physical inventory by lots/serial nos./variants
Physical inventory can hold items with tracking codes or variants. For these items, on Physical inventory journal lines, after Inventory calculation, there will be fields filled with Lot/Serial nos. information, and for items with variants there is a field for variant code.
- If after counting inventories turns out there is a serial number that was not on recorded inventories, that serial number has to reclassify.
In that scenario, go and process one more time Inventories calculation with filter of that item and Serial no./Lot no. There will be new journal line with 0 quantity and serial/lot no. Enter number in Quantity field and post journal line.
- If after counting certain item quantity with tracking or variant needs to reclassify due to exact physical inventories count, you can use functionality for Items reclassification.
๐ถ REP - Reporting
๐น Customer-IOP
Customer - IOP is a report that shows customer's invoices that are partially paid or not paid.
Type in the search bar Customer - IOP. The following options are available on the open page:
Options:
- Show Customers Without Open Entries: show customers without open entries in the report.
- Show Amounts in LCY: set field to print all amounts on a report in LCY. If the field is not set, amounts on reports are shown in foreign currency and in domestic currency, both.
Filter: Customer
- No: choose customer no. if needed.
Filter totals by:
- Date Filter: enter period for a date that entries should be printed.
- Customer Posting Group Filter: choose customer posting groups that you want to filter when printing report.
Choose Print or Preview action to print or show a document.
๐น Vendor-IOP
Vendor - IOP is a report that shows vendor's invoices that are partially paid or not paid.
Type in the search bar Vendor - IOP. The following options are available on the open page:
Options:
- Show Vendors Without Open Entries: show vendors without open entries in the report.
- Show Amounts in LCY: set field to print all amounts on a report in LCY. If the field is not set, amounts on reports are shown in foreign currency and in domestic currency, both.
Filter: Vendor
- No: choose vendor no. if needed.
Filter totals by:
- Date Filter: enter period for a date that entries should be printed.
- Vendor Posting Group Filter: choose vendor posting groups that you want to filter when printing report.
Choose Print or Preview action to print or show a document.
๐น Purchase Price Calculation
The purchase calculation shows the item charge costs associated with that receipt as well as the unit cost LVT (domestic currency) and DVT (foreign currency).
This report can be printed from the Posted Purchase Receipt Document.
Type in the search bar Posted Purchase Receipt Document. On the open list click on the Posted Purchase Receipt Document Number to print the report. At the Actions tab select Purchase Price Calculation.
The following options are available on the open page:
- Show Value Entries
- Show amounts in ACY
Filter Purch. Rcpt. Line
- Document No.
Choose Print or Preview action to print or show a document.
๐น NPS Inventory-Transaction Detail
This report shows the value and quantity changes in the condition of items by locations and document numbers. The changes of items can be tracked by their seral numbers / lots.
The report can be used to manage the issuance of reminders or to prepare liquidity analyses.
Type in the search bar NPS Inventory - Transaction Detail. The following options are available on the open page:
Options:
- New Page per Item:
- Sort by Date:
- Show output at actual prices:
- Show Summary:
- Hide Transit Location:
- Show items without entries:
Filter: Item
- No
- Description
- Assembly BOM
- Inventory Posting Group
Filter totals by:
- Date Filter
Filter: Item Ledger Entry
- Entry Type
By clicking the button Preview on the request page, the report will be presented.
Differences from standard reports
Added columns:
- Serial No.
- Code
- Client Name
- Location
- Inventory
- Price
- Increases Value
- Decreases Value
- Inventory Value
๐น Stock List
Stock list is a report that shows the availability of items by location in the quantity expressed in their units of measure. The availability of items can be tracked by their serial numbers / lots.
Type in the search bar Stock List. The following options are available on the open page:
Options:
- On Date: choose the date.
- Show Items Without Inventory
- Show Item Tracking
- Show Item Variant
- Show Variants And Tracking
- Show Bin Content
- Show Low Details
Filter: Item
- No
- Item Category Code
Filter totals by:
- Location Filter
- Bin Filter
Choose Print or Preview action to print or show a document.
๐น NPS Customer - Detail Trial Balance
Shows a detail trial balance with entries for selected customers for a selected period. This report provides with further details on Customer balance accounts. It also comes with enhanced possibility of viewing customer ledger entries by customer posting group. The report can be used at the close of an accounting period, for example, or for an audit.
Type in the search bar NPS Customer - Detail Trial Balance. The following options are available on the open page:
Options:
Show amounts in LCY: Place a check mark in the check box if you want amounts in the report to be displayed in LCY.
New page per customer: Place a check mark in the check box if you want each customer's detail trial balance to be printed on a separate page.
Exclude Customers That Have a Balance Only: Place a check mark in the check box if you want entries displayed for customers that have a balance but do not have a net change during the selected time period.
Filter: Customer
No: choose customer no. if necessary
Filter totals by:
Customer Posting Group Filter: choose vendor posting groups that you want to filter when printing report
Date Filter: enter period for a date that entries should be printed
You can print balance to date for all customers, by vendor posting groups or you can choose only one.
By clicking the button Preview on the request page, the report will be presented.
Differences from standard reports Customer posting group filtering enabled, the report shows the amount relative to the set of customer posting group filter.
๐น NPS Customer - Summary Aging Simp
This report shows a list of the customers' balances due in LCY divided into seven time periods: not overdue; 0-30 days overdue; 31-60 days overdue; 61-90 days overdue; 91-180 days overdue; 181-360 days overdue; and more than 360 days overdue.
The report can be used to manage the issuance of reminders or to prepare liquidity analyses.
Type in the search bar NPS Customer - Summary Aging Simp. The following options are available on the open page:
Options:
- Starting Date: Enter a date to specify the beginning of the period covered by the report.
Filter: Customer
- No
- Search name
- Statistics Group
- Payment Terms Code
Filter totals by:
- Customer posting group
By clicking the button Preview on the request page, the report will be presented.
Differences from standard reports
Customer posting group filtering enabled, the report shows the amount relative to the set of customer posting group filter, additional option to print the amount in LCY, customers' balances due in LCY divided into seven time periods (added 181-360 days overdue; and more than 360 days overdue).
๐น NPS Customer - Sales List
This report shows sales per customer within time period.
Enhancements comes with the option for filtering by Customer Posting Group.
Type in the search bar NPS Customer - Sales List. The following options are available on the open page:
Options:
- Amounts (LCY) Greater Than: Specifies an amount so that the report will only include those customers to which you have sold more than this amount within the specified dates.
- Hide Address Detail: Place a check mark in the check box if you do not want the report to show address details for each customer.
Filter: Customer
- No: enter customer number if desired
Filter totals by:
- Date Filter: to select a time period
- Customer posting group: to select specific customer posting group
It can be processed and previewed without filters. It will show even Customers with 0 LCY balance.
By clicking the button Preview on the request page, the report will be presented.
Differences from standard reports Customer posting group filtering enabled, the report shows the amount relative to the set of customer posting group filter.
๐น NPS-Customer Balance to Date
This report helps to inquire information about balance per customer on the specific date. It shows all the customers that have open balance. The report can, for example, be used at the close of an accounting period or fiscal year.
Enhancements comes with the option for filtering by Customer Posting Group.
Type in the search bar NPS Customer - Balance to Date. The following options are available on the open page:
Options:
- Ending Date: Specifies the last date until which information in the report is shown. Choose ending date, this option is required.
- Show amounts in LCY: Specifies if amounts in the report are displayed in LCY. Check if needed, if you leave the check box blank, amounts are shown in foreign currencies.
- New page per customer: Specifies if each customer balance is printed on a separate page, in case two or more customers are included in the report.
- Include Unapplied Entries: Specifies if unapplied entries are included in the report.
- Show Entries with Zero Balance: Specifies if the report must include entries with a balance of 0. By default, the report only includes entries with positive or negative balance.
Filter: Customer
- No
- Blocked
- Search name
Filter totals by:
- Customer posting group
- Date
By clicking the button Preview on the request page, the report will be presented.
Differences from standard reports Customer posting group filtering enabled, the report shows the amount relative to the set of customer posting group filter.
๐น NPS Customer - Trial Balance
This report shows a detail balance for selected customers. You can use the report to verify that the balance for a customer posting group is equal to the balance on the corresponding G/L account on a certain date. It shows changes on both Debit and Credit side. It shows the balance at the beginning and the end of the period among with Net changes in between.
The report can, for example, be used at the close of an accounting period or fiscal year.
Enhancements comes with the option for filtering by Customer Posting Group. You can print Trial Balance to date for a Customer or Customer Posting Groups.
Type in the search bar NPS Customer - Trial Balance. The following options are available on the open page:
Filter: Customer Posting Group
Choose if needed to check the report for a certain customer posting group.
Filter: Customer
Select No. if you want to check a report for a certain customer.
Filter totals by:
- Date Filter: Here you need to enter the date period for the report of your interest. It is necessary step in order to get the report rendered and previewed.
By clicking the button Preview on the request page, the report will be presented.
Differences from standard reports Customer posting group filtering enabled, the report shows the amount relative to the set of customer posting group filter
๐น NPS Vendor - Balance to Date
This report helps to inquire information about balance per vendor on the specific date. It shows all the vendors that have open balance. The report can, for example, be used at the close of an accounting period or fiscal year.
Enhancements comes with the option for filtering by Vendor Posting Group.
Type in the search bar NPS Vendor- Balance to Date. The following options are available on the open page:
Options:
Show amounts in LCY: Specifies if amounts in the report are displayed in LCY. Check if needed, if you leave the check box blank, amounts are shown in foreign currencies.
New page per Vendor: Specifies if each vendor balance is printed on a separate page, in case two or more vendors are included in the report.
Include Unapplied Entries: Specifies if unapplied entries are included in the report.
Show Entries with Zero Balance: Specifies if the report must include entries with a balance of 0. By default, the report only includes entries with positive or negative balance.
Use External Document No: Specifies if you want to print the vendor's document numbers, such as the invoice number, for all transactions. Clear this check box to print only internal document numbers.
Filter: Vendor
- No.
- Search name
- Blocked
Filter totals by:
- Date Filter
- Vendor posting group
By clicking the button Preview on the request page, the report will be presented.
Differences from standard reports Vendor posting group filtering enabled, the report shows the amount relative to the set of vendor posting group filter.
๐น NPS Vendor - Detail Trial Balance
Shows a detail trial balance with entries for selected vendors during a selected period. This report provides further details on vendor balance accounts. It also comes with enhanced possibility of viewing vendor ledger entries by vendor posting group.
The report can be used at the close of an accounting period, for example, or for an audit.
Each transaction is shown by the document type such as Invoice, Credit Memo, Compensation, Payment.
Type in the search bar NPS Vendor - Detail Trial Balance. The following options are available on the open page:
Options:
-
Show Amounts in LCY: set field to print all amounts on a report in LCY. If the field is not set, amounts on reports are shown in foreign currency and in domestic currency, both.
-
New Page per Vendor: set a field to print each vendor on a separate page in case two or more are included in the report.
-
Exclude Vendor that have a balance only: set field not to print entries for vendors that have only balance in a certain period, but do not have any posted entries for the period.
Filter: Vendor
- No: choose vendor no. if necessary
Filter totals by:
-
Vendor Posting Group Filter: choose vendor posting groups that you want to filter when printing report
-
Date Filter: enter period for a date that entries should be printed
You can print balance to date for all vendors, by vendor posting groups or you can choose only one.
By clicking the button Preview on the request page, the report will be presented.
Differences from standard reports Vendor posting group filtering enabled, the report shows the amount relative to the set of vendor posting group filter.
๐น NPS Vendor - Purchase List
This is a useful report with attention to all the purchases within the certain time period, summarized per vendor.
Enhancements comes with the option for filtering by Vendor Posting Group.
Type in the search bar NPS Vendor - Purchase List. The following options are available on the open page:
Options:
-
Amounts (LCY) Greater Than: Specifies an amount so that the report will only include those vendors to which you have sold more than this amount within the specified dates.
-
Hide Address Detail: Place a check mark in the check box if you do not want the report to show address details for each vendor.
Filter: Vendor
- No: enter vendor number if needed
Filter totals by:
-
Date Filter: to select a time period
-
Vendor Posting Group Filter: to select specific vendor posting group
It can be processed and previewed without filters. It will show even Vendors with 0 LCY balance.
By clicking the button Preview on the request page, the report will be presented.
Differences from standard reports Vendor posting group filtering enabled, the report shows the amount relative to the set of vendor posting group filter.
๐น NPS Vendor - Summary Aging Simp
This report shows a list of the vendors' balances due in LCY divided into seven time periods: not overdue; 0-30 days overdue; 31-60 days overdue; 61-90 days overdue; 91-180 days overdue; 181-360 days overdue; and more than 360 days overdue.
The report can be used to manage the issuance of reminders or to prepare liquidity analyses.
Type in the search bar NPS Vendor - Summary Aging Simp. The following options are available on the open page:
Options:
- Starting Date: Enter a date to specify the beginning of the period covered by the report.
- Print Amount in LCY: Mark if you want to print amounts in LCY.
Filter: Vendor
- No.
- Search name
- Statistics Group
- Payment Terms Code
Filter totals by:
- Vendor Posting Group Filter
By clicking the button Preview on the request page, the report will be presented.
Differences from standard reports Vendor posting group filtering enabled, the report shows the amount relative to the set of vendor posting group filter, additional option to print the amount in LCY, vendors' balances due in LCY divided into seven time periods (added 181-360 days overdue; and more than 360 days overdue).
๐น NPS Vendor - Trial Balance
This report shows the balance in the beginning of the selected period, net changes recorded within the period and ending balance. Amounts are shown in LCY. It shows changes on both Debit and Credit side.
The report can be used at the close of an accounting period, for example, or for an audit.
Enhancements comes with the option for filtering by Vendor Posting Group. You can print Trial Balance to date for a Vendor or Vendor Posting Groups.
Type in the search bar NPS Vendor - Trial Balance. The following options are available on the open page:
Filter: Vendor Posting Group
Choose if needed to check the report for a certain vendor posting group.
Filter: Vendor
Select No. if you want to check a report for a certain vendor.
Filter totals by:
- Date Filter: Here you need to enter the date period for the report of your interest. It is necessary step in order to get the report rendered and previewed.
By clicking the button Preview on the request page, the report will be presented.
_ Differences from standard reports_ Vendor posting group filtering enabled, the report shows the amount relative to the set of vendor posting group filter.
๐น NPS Trial Balance With Start Balance
This report shows Credit and Debit Balance, Net Charge and Net Charge Balance for each G/L Account, group and class of G/L Accounts on the specific date.
Type in the search bar NPS Trial Balance With Start Balance. The following options are available on the open page:
Options:
- Data Filter
- Rounding Factor
- Skip account without Net Change
- Print to Excel
Filter: G/L Account
- No
- Account Type (Posting, Heading, Total, Begin-Total, End-Total)
Filter totals by:
- Dimension
- Budget
Choose Print or Preview action to print or show a document.
Differences from standard reports
Added options:
- Rounding Factor
- Skip Account without Net Change
- Print to Excel
Added columns: Start Balance, Net Change Balance.
๐น Vendor - Detail Trial Bal. in Curr. and LVT
Shows a detail trial balance in currency and LVT with entries for selected vendors during a selected period. It also comes with enhanced possibility of viewing vendor ledger entries by vendor posting group.
Each transaction is shown by the document type such as Payment, Invoice, Credit Memo, Finance Charge Credit Memo.
Type in the search bar Vendor - Detail Trial Bal. in Curr. and LVT. The following options are available on the open page:
Options:
-
New Page per Vendor: set a field to print each vendor on a separate page in case two or more are included in the report.
-
Show Foreign Exchange Diff.
-
Show Summary
Filter: Vendor
- No: choose vendor no. if necessary
Filter: Vendor Ledger Entry
- Document Type: mark document type from list
- Vendor Posting Group: choose vendor posting group
Filter totals by:
- Date Filter: enter period for a date that entries should be printed
You can print balance to date for all vendors, by vendor posting groups or you can choose only one.
By clicking the button Preview on the request page, the report will be presented.
๐น Customer - Detail Trial-Bal. in Curr. and LVT.
Shows a detail trial balance in currency and LVT with entries for selected customers during a selected period. It also comes with enhanced possibility of viewing customer ledger entries by customer posting group.
Each transaction is shown by the document type such as Payment, Invoice, Credit Memo, Finance Charge Credit Memo.
Type in the search bar Customer - Detail Trial Bal. in Curr. and LVT. The following options are available on the open page:
Options:
-
New Page per Customer: set a field to print each customer on a separate page in case two or more are included in the report.
-
Show Foreign Exchange Diff.
-
Show Summary
Filter: Customer
- No: choose customer no. if necessary
Filter: Customer Ledger Entry
- Document Type: mark document type from list
- Customer Posting Group: choose customer posting group
Filter totals by:
- Date Filter: enter period for a date that entries should be printed
You can print balance to date for all customers, by customer posting groups or you can choose only one.
By clicking the button Preview on the request page, the report will be presented.
๐น Commitent Analysis Summary
This report shows the analysis of Customers, Vendors, Bank Accounts, Employees, Fixed Assets distributed by G/L accounts. The report presents the following data: starting balance, debit amount, credit amount, not due and overdue amounts.
Type in the search bar Commitent Analysis Summary. The following options are available on the open page:
- Period Length
Filter: G/L Entry
- Posting Date: Here you need to enter the date period for the report of your interest. It is necessary step in order to get the report rendered and previewed.
- G/L Account No.
- Source Type
- Source No.
Choose Print or Preview action to print or show a document.
๐ถ Sending Invoice Outstanding Position
For the purpose of sending Invoice Outstanding Position from BC, the following setup is required. Enter Set Up Email in the search bar.
OPTION 1- Microsoft 365: A shared mailbox from which emails are sent. This setup is intended for users with a Microsoft license.
OPTION 2 - Current User: Emails are sent from the user currently logged into BC. This setup is also intended for users with a Microsoft license.
OPTION 3 - SMTP Server: Used to send emails via an external mail server.
Note: For sending a large number of emails, it is recommended to use the SMTP option. The parameters for the SMTP server can be obtained from your IT administrators.
Enter Email Scenario Assignment in the search bar to assign a scenario for sending IOP using this account.
If we want to send Invoice Outstanding Positions from an account that is not the default, it is necessary to assign a scenario. This refers to the shared account.
By selecting Customer IOP and Vendor IOP, you enable sending Invoice Outstanding Positions through this email account, which is not the default.
๐น Selecting the report for sending (sales and procurement)
Enter Report Selection โ Sales in the search bar. In the usage dropdown, select Customer IOP.
The same applies for procurement; select Vendor IOP.
Note: If needed, the email text can be changed via the Word Layout.
๐น Settings on the customer/vendor card
You need to go to any customer/vendor card to assign the Document Layout, which includes the Invoice Outstanding Positions for sending via email. This does not need to be done on every customer card; it is only necessary to configure it once on one card.
You will receive a list of reports for sales, and it is necessary to add the path to the email attachment (Invoice Outstanding Position) in the Email Attachment Layout field.
Email Body Layout โ It can be changed to include any desired text. You can even set a specific text for a particular customer, so that only they will receive the customized text in their email. The same applies to vendors; you will receive the document layout for procurement. It is also possible to modify the Email Body Layout, and you will need to configure the Email Attachment Layout as well.
๐น Email on the Customer/Vendor Card
For each customer and vendor, it is necessary to enter the email address and language code in the Address and Contacts tab. If something is being sent to a foreign customer or vendor, it will be in English if the language code ENG is filled in on their card.
๐น Sending Emails
Emails can be sent in bulk from the customer list using the Actions -> Send Invoice Outstanding Position Emails to Customers function, or individually from the customer card. The same applies to vendors.
Customer Email โ IOP:
Show Customers Without Open Items: Displays customers who have no open items, with a balance of 0.00.
Show Amounts in LCY: Displays amounts in the local currency.
View Customer IOS: Allows previewing without sending.
No.: Enables filtering by customer number.
Date Filter: This field is mandatory, and the end date for viewing open items must be entered. BC automatically sets the start date, so only the end date needs to be specified.
Preview & Close: Allows previewing if the View Customer IOS checkbox is selected; otherwise, the IOP will be sent to the customer's configured email address.
๐ถ FAM - Fixed Assets Management
๐น FA History
Functionality enables tracking of Fixed assets location and responsible employee/customer changes. Functionality also includes report, with the purpose to verify where specific FA is/was or to whom it is/was assigned.
Fixed Asset Setup
To enable FA history entries and therefore the following report, it is necessary to activate field Enable FA History on the page Fixed Asset Setup.
- Open Fixed Asset Setup.
- Set field Enable FA History to enable posting of FA History Entries when Location or Responsible Employee is changed on Fixed Asset Card.
How to update information on FA Location Code - Responsible Employee - Responsible Customer on Fixed Asset Card
For each fixed asset, you must set up a card, containing information about the asset. If you want to log changes that are made on Fixed Asset, you should check the steps below.
- Open Fixed Asset Card.
- Enter or change a value in the field FA Location Code - Responsible Employee - Responsible Customer. The program shows a message to assign a change to Fixed Asset. By choosing an option "Yes", FA Location Code - Responsible Employee - Responsible Customer is changed/entered. The program automatically creates a new entry in FA History table with all related data.
- The program also shows a message to print FA Assignment/Discharge. This report can be printed by choosing a button Preview.
- You can check new entries by choosing History Entries on button History on Navigate Tab.
Print FA Assignment/Discharge Report
If you want to print changes about FA Location Code, Responsible Employee or Responsible Customer, you can do that any time.
- Open Fixed Asset card.
- Go to Report tab and find/print FA Assignment/Discharge report.
- This report can be filtered by FA History entry:
- Type: Location, Employee, Customer
- Additional filters: Date, Old value, New value, Entry noโฆ
How to check FA history entries
FA history enabling provides that all the changes of Location, Customer or Employee are recorder and available through FA History entries.
- Go to search option and type FA history entries
- Entries will enlist by No., Type, FA No., Old value, New value, Creation date and some extra information.
How to print FA history report:
FA history entries can be analysed through FA history report.
- Find and open FA history report
- Group by: Location, Responsible employee, Responsible customer
- As of date: type the date after the changes are made in order to get information
- Filter: FA history entry
- You can choose between FA No., Creation date, Type, New value, Old value
๐น FA Preparation posting type
Analytical record of fixed assets is extended by additional setting and extension for fixed assets that are not yet being active and in use. These fixed assets should be posted through separate account for FA in preparation, Preparation account.
How to set up FA posting groups:
To set up and use this functionality, it is necessary to update information within FA posting groups. Therefore, new Preparation account is to be defined in the same column name.
- Go to FA posting groups. Write down the Preparation account in the column Preparation
- As a result, if selected on Purchase documents, among with Acquisition cost, posting will go through Preparation account instead of Acquisition cost account
How to choose Preparation on Purchase documents:
As previously mentioned, it is necessary to post FA purchase differently if your fixed asset is not planned for immediate activation and usage.
- On the Purchase order lines, FA posting type is to be Acquisition cost
- Next step is to find column FA preparation and check in order to activate new posting functionality
How to activate FA:
- For FA activation go to FA list, select the FA for activation and choose button โActivate Fixed assetโ on the Action ribbon
- The same action is possible within FA card through Actions โ โActivate Fixed assetโ
- This posting creates two FA/GL journal lines, for each fixed asset and two FA and G/L entries accordingly. This amount transfers from FA preparation account to FA Acquisition account, and FA is ready in use
๐น FA Details
Functionality is enabled for overview and analyses of Fixed assets posting transactions types and dates such as: preparation, activation, depreciation, acquisition cost, maintenance, insurance.
-
Open Fixed asset details report and set filters:
-
Options:
- Depreciation book: choose entries to print
- New page per asset: check if yes
- Include reversed entries: check for reversed entries in report
- Starting date, Ending date: enter to define period for your report
- FA filters:
- No: if you want to choose one, or a few fixed assets
- FA class code: FA group listed by class code
- FA subclass code: FA group listed by subclass code
- Budgeted asset: choose whether to show budgeted fixed assets
Some of the additional filters to use for your report optimisation are Acquisition date, FA posting group, FA posting date filter, Location code, Under maintenance etc.
The report can be printed, reviewed, or sent to pdf, Word or Excel format for further analyses.
๐น Set depreciation on FA classes and subclasses
FA classes depreciation setup
Our feature provides with possibility to define depreciation book, method and percentage by each FA class and subclass. It makes it easier to fill in all necessary information regarding depreciation by only choosing the right class/subclass, instead of filling out each FA detail card separately.
Every company can define FA subclasses in accordance to their particular classification and this functionality will provide simple and easy set up of depreciation types and percentages, set in advance for each particular sublass.
In addition, by local law and regulations, companies are obliged to keep records on tax depreciation book. In that case, you can easily set up classes for tax book along with percentages and by doing so, define in advance important information for this separate depreciation record.
- Search for FA classes: here you can define different classes and depreciation percentages for tax depreciation book. By selecting the class when you create new FA on card, it will automatically set up tax depreciation details
- Search for FA subclasess: with subclasses there is a possibility to set equal depreciation method and percentage for different FA sublasses within the company. There by selecting the subclass, you automatically define depreciation details for your fixed asset
๐ถ DCA - Debit Credit Amounts
๐น Change debit credit side
This functionality allows you to change posting side of transactions. It is provided to change in Customer ledger entries, Vendor ledger entries, Bank account ledger entries and FA ledger entries.
โช๏ธ How to change debit credit side:
- Go to G/L ledger entries
- Choose entry you want to change
- Go to Actions - Functions - Change debit/credit
- It will automatically change side of your entry.
Example:
- Find posted purchase invoice
- Choose entries to change side, for example vendor ledger entry
- Check if it is adjusted in Vendor ledger entries
๐น Red reversal posting
Sometimes a user wants to Undo shipment or a receipt. In these cases, it is more suitable to post this undo as red reversal, causing opposite sign transaction on the same side, instead of making new net change entry on the related account.
General Ledger Setup
To use this functionality, you need to set up some fields on table General Ledger Setup.
- Open General Ledger Setup.
- On field Show Amounts on General tab choose the option All Amounts.
To simplify, in a standard transaction posting, take Purchase credit memo as an example. Without this option, posting entries would show:
G/L account | Debit amount | Credit amount |
---|---|---|
53100 | -100,00 | - |
43500 | 100,00 | - |
If you choose and activate Correction on the Purchase credit memo general tab, posting will change:
G/L account | Debit amount | Credit amount |
---|---|---|
53100 | -100,00 | - |
43500 | - | -100,00 |
It posts correction of vendor balance account on the same credit side, with minus as an opposite sign of the original invoicing posting.
Note: In this example assumption is that our cost account 53100 has already set up posting only on debit side, as cost account usually have.
Example with inventories
The same functionality will correct posting on the same side, without creating new net change. Bellow you will find the example for Purchase credit memo.
Purchase credit memo (inventories)
Account number | Debit amount | Credit amount |
---|---|---|
43500 | - | -1200 |
27000 | -200 | - |
13200 | - | 1000 |
13009 | 1000 | |
13000 | -1000 | - |
13200 - Inventory account; 13009 - Inventory adjustment account; 13000 - Purchase account
๐น "One-side"-posting
โช๏ธ How To Post G/L Accounts only on Debit or Credit Amount
Most financial transactions are posted to the general ledger as they are entered on documents or journals. For example, if the amount is entered in the journal window as Debit Amount than the amount is posted on Debit Amount in General Ledger Entry.
For some accounts, there is a need to post the amount only on one side, for example, a Credit amount. For these cases, we can set posting only for a certain side on G/L Account Card.
General Ledger Setup
To enable functionality, you need to set some fields on table General Ledger Setup.
- Open General Ledger Setup
- Go to General tab
- Find field Show amounts and select All amounts
As a result, both credit and debit side will show on different ledger entries: G/L Entries Preview, General Ledger Entries, Apply Customer Entries, Apply Vendor Entries, Bank Account Ledger Entries, FA Ledger Entries, FA Error Ledger Entries, Fixed Asset G/L Journal, Fixed Asset Journal, Recurring Fixed Asset Journal, Maintenance Ledger Entries, Chart of Accounts (Analysis View), Chart of Accounts (G/L), G/L Entries Dim. Overview Matrix
Set up default posting on G/L Account Card
Before posting general ledger entries, you should prepare setup on G/L Account Card.
- Open G/L Account Card
- Go to General tab
- Choose Debit/Credit from options:
-
Both: Posting of all general ledger entries as they are entered on General Journal
-
Debit: Posting all general ledger entries only in Debit Amount side
-
Credit: Posting all general ledger entries only in Credit Amount side
โช๏ธ I Post Journal
Letโs set up one example by choosing G/L account that has a set up to post only on debit side. Our example G/L account will be 51201.
- Open General Journal.
- Enter G/L Account, that has setup for Debit posting
- Enter the Credit Amount
- Enter the G/L Balance Account
- Choose Post action
G/L Account | Debit Amount | Credit Amount | G/L Balance Account |
---|---|---|---|
51201 | - | 100,00 | 70000 |
Check Ledger Entries
- Open General Ledger Entries.
- Check if the amount is posted on Debit Amount (as a negative amount), which was set on G/L Account Card as default posting.
G/L Account | Debit Amount | Credit Amount |
---|---|---|
51201 | -100,00 | - |
70000 | 100,00 | - |
โช๏ธ II Posting Sales Credit Memo
If your Sales credit memo account is set to have posting on credit side, that will create the following situation:
- Open Sales credit memo and create a new document.
- Enter data about customer number, posting date, document date on General tab. Uncheck field Correction on General tab.
- Choose Copy document to select the posted invoice you want to reverse and all change if necessary needed data on Lines Tab.
- Post Sales Credit memo by choosing a post on the action.
Check Posted Sales Credit Memo
- Go to Posted Sales Credit Memo. Open document.
- Choose button Navigate and open General Ledger Entries.
- Amounts are posted on Credit Amount (as a negative amount), as defined in G/L Account Card defined for sales credit memo postings
G/L account | Debit amount | Credit amount |
---|---|---|
61400 | - | -100,00 |
20400 | - | 100,00 |
โช๏ธ III Posting Purchase Credit Memo
If your Purchase credit memo account is set to have posting only on debit side, that will create the following situation:
- Open a Purchase credit memo and create a new document.
- Enter data about vendor number, posting date, document date on General Tab. Uncheck field Correction on General Tab.
- Choose G/L Account that is set as Debit posting and all needed data on Lines Tab.
- Post Purchase credit memo by choosing a post on the action.
Check Posted Purchase Credit Memo
- Go to Posted Purchase Credit Memo. Open document.
- Choose button Navigate and open General Ledger Entries.
- Amounts are posted on Debit Amount (as a negative amount), as defined in G/L Account Card.
G/L account | Debit side | Credit side |
---|---|---|
53100 | -100,00 | - |
43500 | 100,00 | - |
๐ถ VAT - VAT Management
๐น VAT Book Groups
VAT Book Groups In order to be able to define the lines of a VAT reporting form, it is necessary to define VAT Book Groups.
In one VAT Book Group, all VAT identifiers belonging to that VAT Book Group are defined.
VAT Book Groups Setup
- In quick search type _VAT Book
- Enter: Code, Book Link Code, Description
- In a field Group Type choose VAT entries if VAT data is to be entered or Total if the entered data are to be calculated
- In the field Totaling enter the range of VAT Book Groups to be calculated if the Group Type is Total (choose from list ". . .") or leave blank if the Group Type is VAT entries.
VAT Book Groups Identifiers
When the lines of a VAT Book Groups are defined, it is necessary to state the VAT Book Groups Identifiers belonging to that group for each row:
- Select certain line
- Choose VAT Identifiers
- Select from the list the VAT Identifiers required
๐น VAT Identifiers
VAT Identifiers
This topic describes the posting of VAT Identifier when posting VAT entries for a certain combination of VAT Product Posting Group and VAT Business Posting Group from VAT Posting Setup that is entered on an unposted document to VAT Entries.
In order for the amount of VAT to be correctly displayed in a certain VAT book, it is necessary to create the corresponding VAT identifiers. They will be listed later in the VAT identifier field when creating and setting up a VAT book. For easier connection, the Identifier should have the same code as the field in the POPDV form.
VAT Identifiers Setup:
- In quick search type VAT Identifiers
- Choose New
- Enter Code and Description
๐น VAT Books
VAT Books In accordance with the valid legal regulations related to VAT, in Serbia, there is an obligation to keep appropriate VAT records. In order for the VAT to be adequately calculated and reported, the functionality of the VAT book has been created, which users can adjust themselves for the necessary reports such as KUF, KIF, POPDV ... VAT Books Setup
To access the setting of VAT books, type VAT books in the quick search
POPDV
Books should be defined so that each unit within the POPDV form makes one VAT book.
For each VAT book, it is necessary to set:
- column names,
- VAT book groups and identifiers,
- set amount displays,
- export tags in XML.
- Click New to create a new book
- Enter the VAT book code (1,2,3โฆ 11) in the code field
- In the Description field enter the name of that book.
After entering the new VAT book, as one unit of the POPDV form, it is necessary to set the appropriate columns:
Go to process->Column Name Setup
-
Click New to create a new line
-
Enter Column No. and Description
After adjusting the columns, the lines of the form are adjusted. This is done through VAT Book Groups. Each line of the POPDV form should be defined as one group within the VAT book.
Finally, it is necessary to define a formula for adding the amount:
- Go to Process->VAT Book Setup
- Clicking on the field defines the amount to be calculated in that field. Offered options:
- Operator 1 - Sign for the amount to be displayed in the Value 1 column. It contains two options (- and +). Depending on whether it is purchase or sales VAT.
- Value 1 - Clicking the arrow in this field opens a list of options that contains:
- Base Amount
- VAT Amount
- Amount Inc. VAT
- Base Amount (retro)
- Unrealized Base
- Unrealized Amount
- Unrealized Amount Inc. VAT
- VAT Retro
- Amount Inc. VAT (retro)
Once the POPDV form has been set up, a report review can be run:
- Go to VAT Books-> Reportrs-> VAT Calculation Details
- Enter the date filter (for example 010120..310120)
๐น Postponed VAT
The Postponed VAT feature is used every time the VAT amount is to be suspended as it is not possible to settle it at a given time. In case when posting purchase invoice is in one accounting period and VAT is in another, it is necessary to postpone the deduction of the VAT amount.
Postponed VAT is used in sales and purchases.
SALES
PURCHASE
Post Purchase or Sales Invoice
- Open Purchase or Sales Invoices and create a new document.
- Enter data about vendor number, posting date, document date on General Tab.
- Field VAT Date on General Tab must be empty, then description in field Postponed Vat on General Tab will be โPostponed VATโ
- Check General Ledger Entries for posted Purchase or Sales Invoice. VAT Amount is posted on the Purchase or Sales Postponed VAT Account.
PURCHASE
SALES
- Check VAT Entries for posted Purchase Invoice.
VAT Bus. Posting Group | Posting Date | Document Type | Type | Base | Amount | Unrealized Amount | Unrealized Base |
---|---|---|---|---|---|---|---|
DDOM | 13.07.2020 | Invoice | Purchase | 0,00 | 0,00 | 1.000,00 | 5.000,00 |
Realize postponed VAT on Posted Purchase Invoice
- Go to Posted Purchase Invoices. Open document.
- Choose Navigate->Invoice->Functions->Post Postponed VAT and enter VAT Date that should be posted for the Purchase Invoice.
- Choose button OK to post realization of VAT to VAT Entries and to General Ledger Entries.
Check General Ledger Entries that are posted on realized VAT Date.
G/L Account No. | Debit Amount | Credit Amount | Posting Date |
---|---|---|---|
43500 | 0,00 | 6.000,00 | 13.07.2020 |
28990 | 1.000,00 | 0,00 | 13.07.2020 |
28990 | 0,00 | 1.000,00 | 13.07.2020 |
27000 | 1.000,00 | 0,00 | 15.07.2020 |
10000 | 5.000,00 | 0,00 | 15.07.2020 |
VAT Entries must be posted on realized VAT Date
VAT Bus. Posting Group | Posting Date | Document Type | Type | Base | Amount | Unrealized Amount | Unrealized Base |
---|---|---|---|---|---|---|---|
DDOM | 13.07.2020 | Invoice | Purchase | 0,00 | 0,00 | 1.000,00 | 5.000,00 |
DDOM | 15.07.2020 | Invoice | Purchase | 5.000,00 | 1.000,00 | 0,00 | 0,00 |
Correct postponed VAT |
- Go to posted Purchase invoice
- Choose Navigation->Invoice->Functions->Correct postponed VAT
- Enter VAT Date that should be corrected
- Choose button OK to post VAT Entries and General Ledger Entries.
Check General Ledger Entries that are posted on realized VAT Date.
VAT Entries must be posted on corrected VAT Date.Additional VAT Entry is created but original entry is updated with Remaining Corrected Base and Remaining Corrected Amount.
๐น Reverse Charge VAT
Reverse Charge Vat applies to some purchases from abroad. Purchases will be calculated according to Reverse Charge VAT, which is defined by the VAT Law.
For posting Reverse Charge Vat you need VAT posting Setup. Enter in the search bar VAT posting Setup.
Following fields need to be set:
โข VAT Business Posting Group
โข VAT Prod. Posting Group
โข VAT Calculation Type
โข VAT %
โข VAT Identifier
โข VAT % (retrograde)
โข Reverse Chrg. VAT Acc.
โข Purchase VAT Account
When you make this setup, you can post a purchase invoice. Two VAT entries will be created in the general ledger.
๐น Reverse Charge VAT - LCY
๐ถ RVE - Reverse
๐น Reverse orders
โช๏ธ How to set up reverse order functionality:
- First step is to set Locations for source type โ Vendor, Customer or Employee. Search Locations and add a new one. The field โLocation for outside goodsโ is to be set with the value of source type and โUse as transit locationโ needs to be checked.
- It is necessary to adjust Inventory posting setup. New locations/items combination is to be created fot posting items you want to enable transfering from/to.
Example: If our location is for Employees, and we want to transfer Minor assets, this item posting group has to be defined as in correlation with Employees location
Location code | Inventories posting group | Inventory account |
---|---|---|
EMPL_LOC | Minor assets | 10100 |
โช๏ธ How to create Reverse order:
Go to search and find Reverse order list and select New. There is a set of fields to enter data:
- No: revers order number
- Transfer-from code: specifies the code of the location items are transfered from
- Transfer-to code: specifies the code of the location items are transferred to after items is returned from source type(employee, customer or vendor).
- In-transit code: specifies the transit location where the item is located by the assignment, according to source type, this location correlates with the source type.
By choosing In-transit code, the field source type is automatically filled in. Next step is to choose source no โ employee, vendor or customer number.
- Source type: It will be employee, customer or vendor
- Source no: Choose employee, customer or vendor number
- General business posting group: choose business posting group for reverse orders
- Posting date: the date when item release is posted Return date: the date when item is expected to be returned from employee, customer or vendor
With reverse order header completed, next is to add items for transfer in Reverse lines tab:
- Item no.: choose item
- Quantity: choose quantity
- Unit of measure code: write in unit of measure code
Note: When assigning item with tracing by lot or serial number, it is necessary to fill in tracing lines (Lines โ Item tracking lines โ shipment)
โช๏ธ Releasing items โ posted reverse shipment:
After you have assigned items to specific source type and location accordingly, the next step is posting on path Process โ Post โ Ship.
It will create posted reverse shipment, assigning this item to the source type. The following status change changes to Released and field Quantity shipped is changed in Reverse lines.
With posted shipment reverse, two item ledger entries are posted:
- Taking off quantity from Transfer-from location
- "Placing" that quantity in In-transit location
Posted reverse shipment can be found from reverse order, through menu Navigate โ Documents โ Shipments and it is possible to print out the document.
โช๏ธ Return of items โ posted reverse receipt
When the source type (customer, employee or vendor) returns the item, it is necessary to post reverse receipt and return items to original From-to location. The steps for this action are from Reverse order โ Process โ Post - Receive.
As a result, our reverse order is being deleted, since the process circle is completed, and we have two additional item ledger entries showing:
- The quantity of items returned from source type In-transit location
- "Placing" this quantity to initial Transfer-from location. There is an option to print Posted reverse receipts, accordingly.
๐น Inventory reverse preview
In every moment, there is possibility to check items location (source type) according to reverse assignment/discharge. There is a report called Inventory reverse review.
- Search for this report and choose filters:
- OptionsโPrint details: choose "Yes" if needed to print even posted shipment/receipt reverse numbers and lines. If not, it will only show item quantity assigned with the source type
- No.: number of posted reverse shipment
- Source type: Employee, Customer or Vendor
- Location code: choose one of the locations, for employees, customers or vendors
- Item no.: if we want to check for the reverse order details for particular item no.
- Posting date: it is possible to filter by posting date
Among all filters, Location code is obligatory for report processing.
As usual, there is an option to Send to, Print or Preview the report.
๐ถ DPS - Double-Posting
๐น Direct double posting on account
Double posting should be active if one transaction (ex. Cost of materials) is to be recorded both on class 5 and class 9, by defining two additional accounts: Double posting โ account and Double posting โ balance account.
In cases similar to this one, when one additional cost account is required, it is easy to define two additional double posting accounts (Double posting-account and Double posting-balance account). As a result, we will have regular G/L entries and additionally, class 9 entries.
- Go to Chart of accounts and find Account number for double-posting. Edit Account card, and on the Posting tab activate Double posting option
- Define Double posting โ account and Double posting โ balance account
๐น Double posting through dimension group values
Double posting accounts can depend on a dimension (Cost centre department or any other dimension).
You can select dimensions to be obligatory for double posting and to set up dimension groups codes for dimensions selected for double posting. Groups are related to dimension values. Needed is to define specific accounts for double posting (class 9) for each dimension group code (warehouse, purchase, sales etc).
If, for example, dimension for obligatory double posting was Cost centre dimension, as a result of this setting every posting on cost accounts brings related posting on debit side of class 9, depending on dimension group value for Cost centre that is used on a document.
With dimension group value selection, we practically pre-define posting result, meaning to which account will our transaction double-post after we select certain group dimension value. It is necessary to adjust dimension settings in order to respect this dependence.
- Go to Dimensions and select dimensions for obligatory double-posting
- Next search for Dimensions page, select Dimension โ Dimension values from the ribbon, for dimensions previously selected for double posting
- New page with dimension values will open. On the page, define Group dimension codes
- Go to G/L account card โ Navigation โ Double posting setup and write down account numbers for each group dimension codes
Note: For cost accounts, it is necessary to set dimension posting as required for cost centre.
๐ถ DCT - Document Subtypes
๐น Purchase document subtype
Here is the example with new Purchase document subtype for transactions of return of goods sold. According to specific VAT regulation, in a certain situations this return is to be considered as new outgoing net change and requires new VAT settings.
Therefore, new VAT business posting group is POVDOBIZFA, set up to post this return through outgoing VAT account for sales (470001), instead of incoming account(270001). It is necessary to enter this account in Purchase VAT account field.
Also, there is a new Posting no.series created for this transaction type, PKFPOVDOB.
Code | Description | Doc.type | VAT gen.buss.post.gr. | Posting no.series(Purchase hdr) |
---|---|---|---|---|
POVDOBIZFA | Povrat dobavljacu izl.fakt. izl.pdv | Credit memo | POVDOBIZFA | PKFPOVDOB |
If we select this new Purchase document subtype code, in Purchase credit memo General tab, posting result would look like in the table below:
G/L account | Debit amount | Credit amount |
---|---|---|
96000 | - | 1000,00 |
10009 | 1000,00 | - |
10000 | - | 1000,00 |
470001 | - | 200,00 |
43500 | 1200,00 | - |
96000 | 600,00 | - |
10009 | - | 600,00 |
๐น Sales document subtype
In our example, there is a new sales document subtype for items in use to test new machine.
Code | Description | Doc.type | Gen.buss.post.gr. | VAT buss.post.gr. | Payment method code | Post.no.series |
---|---|---|---|---|---|---|
POTZTPM | Items expenditure for new machines testing | Invoice | POTZTPM | PRESKPDVV | POZTPM | PFKRAS |
Defined sales account for this combination is set to be 62106 (Revenues from activating products to test the operation of a new machine).
VAT buss. post. group is PRESKPDV โ VAT is defined to be 0% and new posting no. series is PKFRAS.
New payment method code is created as POTZPM, with Balance account type set to be G/L cost account 511400 (Spent products for testing new machine). Here we want to post this transaction as an expenditure, since the revenue will be equal to our expenses and to "close" customer balance with posting the transaction. You can create customer for internal purposes to post similar transactions.
As we post our invoice and choose subtype POTZPM in general tab on our sales invoice document, we get G/L entries from the table below:
G/L account | Debit amount | Credit amount |
---|---|---|
96000 | - | 10000,00 |
98000 | 10000,00 | - |
62106 | - | 10000,00 |
20400 | 10000,00 | - |
511400 | 10000,00 | - |
20400 | - | 10000,00 |
๐ถ PPE - Prepayment
๐น Purchase prepayment credit memo
If there has been a mistake with posted Prepayment invoice, it can be reversed with credit memo documents, Sales credit memo for Sales prepayment invoices and Purchase credit memo for Purchase prepayment invoice.
The process is similar, here is to be explained on Vendor prepayment example.
How to undo posted Purchase prepayment invoice
- Open new Purchase credit memo document
- Enter Vendor no, date, document no, and G/L account for Prepayment VAT account in document line (27200) and type 1 in Quantity column field
- On tab General, choose Applies - to Doc. Type (payment, invoices...) and Applies-to Doc. No.
- Go to Invoice Details tab, check Prepayment โyesโ and choose prepayment no.
- Post Purchase credit memo; as a result, prepayment invoice will be reversed and linked to purchase credit memo
๐น Purchase prepayments
The settings are similar to sales prepayment, only with different accounts and posting groups.
Purchase prepayment settings
- Go to Purchase & Payables setup
- Check advance prepayment before posting: activate this option of you want the system to recognize before posting if prepayment % is defined on Sales document lines is actually paid/connected to sales order/invoice
- On Numbering tab, set series nos. for Prepayment purchase invoices and Prepayment purchase credit memos
Vendor posting groups setup
It is necessary to create Prepayment posting group and Prepayment invoice posting group for purchase and to combine them with standard vendor posting groups expected to send prepayments to.
VAT posting group settings
It is required to set up new VAT product posting group and VAT sales account for prepayments and to create relations with vendor posting groups.
VAT product posting group needs to be set with, there is an example with domestic vendor:
Purchase prepayment posting
Purchase prepayments are posted through bank statement. Within Payment journal lines, there is a field to mark payment as a prepayment. With that field and selected Vendor/vendor posting group combination, prepayment will post as previously defined through vendor posting groups settings.
After prepayment posting, next step is to create and post purchase prepayment invoice, to show VAT amount within the prepayment. This can be done through Purchase order or purchase invoice documents.
Create prepayment invoice through Purchase invoice:
- Open new purchase invoice document
- Fill in General tab fields as usual
- Go to purchase invoice lines and type Purchase prepayment VAT account (from this example it will be 27200)
- Go to Invoice detailes tab, check Prepayment โyesโ and choose prepayment no. This will automatically fill in amount without VAT filed in purchase invoice line
- Post the document and check for G/L entries
Create final purchase invoice
- Open Purchase orders/Purchase invoices list and create a new one
- Fill in standard General tab fields and document lines
- On tab Actions โ Functions โ Apply entries
- Choose payment you want to apply invoice with and go to Process โ Set applies to ID
- Post Purchase order/Invoice
- Check Vendor ledger entries
๐น Sales prepayments
โช๏ธ Sales prepayment settings
- Go to Sales & Receivables setup
- On Numbering tab, set series nos. for Prepayment invoices and Prepayment credit memos
Customer posting groups setup
Type in the search bar Customer posting groups. It is necessary to create Prepayment posting group and Prepayment invoice posting group and to combine them with standard posting groups expected to receive prepayments from.
VAT posting group settings
It is required to set up new VAT product posting group and VAT sales account for prepayments and to create relations with customer posting groups.
VAT product posting group needs to be set with:
Prepayment posting
Sales and purchase prepayments are posted through bank statement. Within Payment journal lines, there is a field to mark payment as a prepayment. With that field and selected Customer/customer posting group combination, prepayment will post as previously defined through customer posting groups settings.
After prepayment posting, next step is to create and post prepayment invoice. This can be done through Sales order or Sales invoice documents.
Create prepayment invoice through Sales invoice:
- Open new sales invoice document
- Fill in General tab fields as usual
- Go to sales invoice lines and type Sales prepayment VAT account (from this example it will be 47200)
- Go to Invoice Details tab, check Prepayment โyesโ and choose prepayment no. This will automatically fill in Amount without VAT field in Sales invoice line.
- Post the document and check for G/L entries
Create final sales invoice
- Open Sales orders/Sales invoices list and create a new one
- Fill in standard General tab fields and document lines
- On tab Actions โ Functions โ Apply entries
- Choose payment you want to apply invoice with and go to New โ Set applies-to ID
- Go back to original document and Post Sales order/Invoice
- Check Customer ledger entries
๐ถ Cash-Desk
๐น Cash desk settings
The path is as follows:
- Type in search (ALT+Q) General Ledger Setup/(Cash desk tab) and set Cash Desk Account Nos. Also, there is an action to choose whether Cash desk report is mandatory or not. There is a possibility to enter default cash withdrawal and receipt limits
- Search for Cash Desk Account list to create Cash desk account
Opening a new Cash Desk card and linked Bank Account card requires entering a posting group, no. series for payment journals, no. series for cash reports and currency code.
When posting a cash register, there is an option of choosing the level of posting transactions. There are two levels of transaction posting:
- Directly through the Cash report
- Posting through cash receipt and withdrawal journals
How to create cash desk account
Go to Cash desk account list. In order for the Cash Desk to be active for further postings, it is necessary to initiate an function โ Create bank account (Name field).
Clicking on the three dots opens - Cash Desk Details
In the posting section on Cash Desk Card, fill in:
-
Cash Posting Level
-
Cash Order Receipt Nos.
-
Cash Order Withdrawal Nos.
-
Cash Desk Report Nos.
The first step in posting cash is to open the Cash Reports
When we receive NEW cash reports, the opening date must be filled.
๐น Cash Receipt List
It is necessary to create a Cash Receipt List. Go to search bar and enter Cash Receipt List there and click on New.
In journal line to enter the payment amount in the Cash Order
In order to print the Receipt Cash payment, it is done on reports.
๐น Correction Select Lines and Reverse
It is necessary to create a new Cash Order, where the correction is made. Select lines gives us lines that you can choose. You choose what needs to be corrected.
If you want to Revers the entire cash order, you do it on posted cash orders.
๐น Closed and Post Cash Report
After entering all transactions, it is necessary to change the status of the Cash Report to "closed". When the Receipt/Withdrawal order is posted, the Chas Report can be closed.
If some corrections are needed, the Chas Report can be reopen via the Reopen function.
The Cash Report can be printed by clicking on the print function.
๐น Cash Withdrawal List
Go to search bar and enter Cash Withdrawal List there and click on New.
In journal line to enter the payment amount in the Cash Withdrawal.
In order to print the Cash Withdrawal, it is done on reports.
When the receipt and withdrawal transactions are made, they can be seen on the Cash Report.
๐ถ Document Printout
๐น Internal Invoice
Within the Posted Purchase Invoice, you can access the internal calculation, review it, forward, or print the internal calculation. This is facilitated through a request page that offers a selection of multiple options.
๐น Purchase Credit Memo
Within the Posted Purchase Credit Memo, you can review, forward, or print the document. This is facilitated through a request page that offers a selection of multiple options.
๐น Purchase Receipt
Within the Posted Purchase Receipt, you can review, forward, or print the document. This is facilitated through a request page that offers a selection of multiple options.
๐น Sales Quote
When you want to print Sales Quote, you will receive a data entry and configuration page. The page features several options that can be reviewed and printed.
- Archive Document - To place the document in the Sales Quote Archives, it is necessary to make adjustments on the page Sales & Receivables Setup in the Archiving section.
- Proinvoice will be printed on the document.
- Preview
๐น Sales Credit Memo
Within the Posted Sales Credit Memo, you can review, forward, or print the document. This is facilitated through a request page that offers a selection of multiple options.
๐น Sales Invoice
Within the Posted Sales Invoices, you can review, forward, or print the document. This is facilitated through a request page that offers a selection of multiple options.
๐น Sales Shipment
On a Posted Sales Shipment, you can initiate printing with the following options based on your specific needs.
๐น Sales Pro Forma Invoice
Using the Sales Invoice, you have the option to print a Pro Forma invoice. After creating the Sales Invoices, you can easily generate a Pro Forma invoice directly from the document.
๐น Service Shipment
๐น Service Credit Memo
Within the Posted Services Credit Memo, you can review, forward, or print the document. This is facilitated through a request page that offers a selection of multiple options.
๐น Service Invoice
Within the Posted Sales Invoices, you can review, forward, or print the document. This is facilitated through a request page that offers a selection of multiple options.
๐น Warehouse Posted Receipt
Within the Posted Warehouse Receipt, you can review, forward, or print the document. This is facilitated through a request page that offers a selection of multiple options.
๐น Warehouse Posted Shipment
Within the Posted Warehouse Shipment, you can review, forward, or print the document. This is facilitated through a request page that offers a selection of multiple options.
๐ถ Item FA Reclassification
๐น Reclass FA to Item
The following steps precede the creation and posting of this document are:
- Go to Reclass Item to FA list - Type in search Item to FA Reclass.
- Click on New to create new document
- Enter FA number at document header and posting dates
- Enter item number, location code, quantity and amount in document line
- All other data is transferred from setup
- Entered and checked data document must be posted
- Clicking on Post a new document is created โ Posted Reclass Item to FA journal
- It is possible to print necessary report from the registered document
๐น Reclass Item to FA
The following steps precede the creation and posting of this document are:
- Go to Reclass Item to FA list - Type in search Item to FA Reclass.
- Click on New to create new document
- Enter FA number at document header and posting dates
- Enter item number, location code, quantity and amount in document line
- All other data is transferred from setup
- Entered and checked data document must be posted
- Clicking on Post a new document is created โ Posted Reclass Item to FA journal
- It is possible to print necessary report from the registered document
๐ถ Year-end Process
๐น Create No. Series Line
This functionality allows you to automatically create new No. series lines for the new business year. In quick search type "No. series" and start Create No. Series line function.
On the question form enter the year for which it should be created No. series, then enter the no series code we want to create on the filter tab, then clik "Ok". The system will create new no. series. You can check it on Navigate-Lines as in the pictures below
๐ถ VAT Records โ Bosnia and Herzegovina
For the functioning of the VAT ledger and its reporting, the following setup is required. Enter VAT Posting Setup in the search bar. A window will open for configuring the VAT Business Posting Group and VAT Product Posting Group, with identifiers, VAT percentages, and VAT calculation types.
In the same VAT Posting Setup table, document types are entered in the Document Type field.
Sales Document Types:
01 โ Sales invoices for goods and services
02 โ Sales invoices for personal use (non-business purposes)
03 โ Sales prepayment invoices
04 โ Customs Declaration (Import)
05 โ Sales Other invoices
Purchase Document Types:
01 โ Purchase invoices for goods and services from domestic suppliers
02 โ Purchase invoices for personal use (non-business purposes)
03 โ Purchase prepayment invoices
04 โ Customs Declaration (Import)
05 โ Purchase Other invoices (invoices for services received from abroad)
๐น VAT Books
To comply with legal requirements, a special VAT Books functionality has been created, allowing users to configure reports for the Purchase VAT Book (KUF) and Sales VAT Book (KIF). Within the same book, it is also possible to generate other specific overviews related to VAT records.
You can access VAT Books from the menu or by entering the keyword VAT Books in the search bar.
The VAT books should be defined so that each section within KUF and KIF represents a separate VAT book. For both books, the following settings need to be configured:
-
Column names
-
VAT book groups and identifiers
A new book is created by clicking the New option. Enter the VAT book code (KUF and KIF) in the Code field and the name of the book in the Description field. For each book, appropriate columns must be defined, as shown in the example image.
KIF
KUF
๐น Vat Books Groups
On the VAT Posting Groups page, you enter the VAT Identifiers that are defined in the VAT Posting Setup table. Clicking on VAT Identifiers opens a page for entering all defined identifiers. They are entered separately for KIF and KUF, with each ledger assigned its corresponding identifier.
๐น VAT Book Setup
This section displays the column names entered for the KUF and KIF books. By clicking Edit list, the fields can be modified.
๐น VAT Review
You can easily modify the date filter at any time to match your needs.
๐น VAT reports
The VAT reports used for Bosnia and Herzegovina are the VAT Book and VAT Return Export to CSV.
By clicking Export VAT Books to CSV, a page for entering the date filter will open. After clicking OK, the file will be exported and ready for further import into the VAT return submission system.
๐ถ Fiscalization for Bosnia and Herzegovina
To establish a connection between the fiscalization service and Business Central, you need to search for Service Connections -> Fiscalization Application Setup (BIH).
A setup page will appear where you need to select Fiscalization Implementation (TRING) and configure the URL, as shown in the image.
You will get the URLs in the Service tab and the Service Paths tab.
The final step is to click Enable, and the connection will be activated. The remaining options within the setup are explained further in the text.
๐น Printing of the fiscal receipt
From the Posted Sales Invoices document, initiate the Print Fiscal Receipt with Customer action.
Note: If the invoice is in a foreign currency, it will be sent to fiscalization in the local currency.
Once the invoice is successfully fiscalized, it will receive a Fiscal Inv. Sales No., which can be seen in the Invoice Details tab.