Export Goods Received

A quick introduction to Bizzfo Goods Received Export

Introduction

Use the export function to extract goods received data from the system

There are two options to extract data

Option 1 correlates with the goods received import

Option 2 is part of the standard export within Bizzfo

Option 1

Open goods received screen

Go to goods received and click on the file menu.

Select the date period to export

The export file will be in the format as shown below. Note that each line is a summarized version of the Goods Received Note.

Below is the field definition matrix for the Goods Received import file

Field Name	Expected value	Notes
Account	Unique supplier code	Can be blank
Name	Company name	Name of supplier. If it does not exist in the system, it will be created. Name must be unique
Date	Expected format dd/mm/yyyy	Can not be blank. Format must be day/month/year
Reference	Invoice\Document number
Notes	Not used
OrderNumber	Not used
Code	IN = Invoice CR = Credit note	State if document is a credit note or an invoice
Vatrate	0 or 1	VAT Rate. If set to 1, then system VAT is applied. If set to 0 then no VAT calculation is applied
Ldgr Account	STOCK	Ledger Account. Will default to Stock if value is not set correctly. See accounts to use
Rep	Not used
Amount	Currency incl VAT	Total amount for the goods received document.

Option 2

Exporting Bizzfo Data Grid

1. Select all rows

2. Export to CSV