Sage 50 UK GRN XML
The Import Goods Received Note task allows you to receive items on purchase orders already in Sage. Note that for an order / order item to be received it must be in the correct state in Sage - the order must not be fully received or fully cancelled, and at least part allocated. The quantity for the order item must not exceed the quantity allocated / ready to receive.
The status of the order in Sage will be updated depending on the current state, and result of the import. The status will either not be updated, updated to complete or updated to part received.
Tasks
XML
Any Sage fields not documented below are not supported with our imports. Examples of where in the XML the fields should appear are shown in the samples below.
Sage Field | XML Field | Example | Field Type | Field Length | Input |
---|---|---|---|---|---|
N/A | Id | 123 | int | - | Optional |
A/C Reference | AccountReference | MCN001 | string | 8 | Required |
N/A | Type | GoodsReceivedNote | string | - | Required |
Order No. | OrderNumber | 38 | int | - | Required |
Supplier GRN | Reference | PROJ006 | string | 20 | Required |
GRN Date | Date | 2012-10-03T10:00:00 | datetime | - | Required |
Product Code | Sku | PC005 | string | 30 | Required |
Quantity | Quantity | 1.00 | double | - | Required |
Product Cost Price | CostPrice | 780.41 | double | - | Optional |
Sample import file for receiving an item on an order:
<?xml version="1.0" encoding="utf-8"?>
<Company
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<GoodsNotes>
<GoodsNote>
<Id>123</Id>
<AccountReference>MCN001</AccountReference>
<Type>GoodsReceivedNote</Type>
<OrderNumber>38</OrderNumber>
<Reference>PROJ006</Reference>
<Date>2012-10-03T10:00:00</Date>
<Sku>PC005</Sku>
<Quantity>1.00</Quantity>
<CostPrice>780.41</CostPrice>
</GoodsNote>
</GoodsNotes>
</Company>
Grouping
Individual goods notes can be grouped together to form a single Goods Received Note in Sage, with multiple item lines. Consecutive goods notes in the XML will be grouped where the following fields contain the same value on each goods note:
- OrderNumber
- Date
- Reference