Goods Issues - codbex/codbex-olympus GitHub Wiki
A Goods Issue Note (GRN) is a document used in the sales and inventory management process to confirm the issue of goods to a customer.
GoodsIssue
Entity Definition
- Entity Type:
Primary Entity - Layout Type:
Manage Master Entities - Module: https://github.com/codbex/codbex-inventory
| Field | Type | Length | Null? | Calc? | Ref? | Description |
|---|---|---|---|---|---|---|
| Id | INTEGER | no | - | - | ||
| Number | VARCHAR | 20 | no | - | - | |
| Date | DATE | no | - | - | ||
| Store | INTEGER | - | - | yes | Reference to Stores | |
| Company | INTEGER | - | - | yes | Reference to Companies | |
| Currency | INTEGER | - | - | yes | Reference to Currency | |
| Net | DOUBLE | - | yes | - | SUM(SalesInvoiceItem.Net) | |
| Gross | DOUBLE | - | yes | - | SUM(SalesInvoiceItem.Gross) | |
| VAT | DOUBLE | - | yes | - | SUM(SalesInvoiceItem.VAT) | |
| Name | VARCHAR | 200 | - | yes | - | Supplier.Name/Number/Date/Total |
| UUID | VARCHAR | 36 | - | yes | - | Random UUID generated |
| Reference | VARCHAR | 36 | - | - | - | Reference via UUID to the PurchaseOrder |
Custom Actions
GoodsIssueItem
Entity Definition
- Entity Type:
Dependent Entity - Layout Type:
Manage Details Entities
| Field | Type | Length | Null? | Calc? | Ref? | Description |
|---|---|---|---|---|---|---|
| Id | INTEGER | no | - | - | ||
| GoodsIssue | INTEGER | no | - | yes | Reference to Goods Issue | |
| Product | VARCHAR | 2000 | no | - | - | Reference to Product |
| Quantity | DOUBLE | no | - | - | ||
| UoM | INTEGER | - | - | - | Reference to the UoM | |
| Price | DOUBLE | no | - | - | ||
| Net | DOUBLE | - | yes | - | Quantity * Price | |
| VAT | DOUBLE | - | - | - | ||
| Gross | DOUBLE | - | yes | - | Net + VAT |