Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Is there module for Generate Malasian GST Audit File (GAF) in Text File Format (XML file and a Bar-Delimited-File)

By
Aravinth
on 5/31/14, 4:18 AM 1,612 views

XML Schema(Input)

<?xml version="1.0" encoding="utf-8"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:annotation>
<xsd:documentation xml:lang="en">GST Audit File (GAF)</xsd:documentation>
</xsd:annotation>
<xsd:element name="GSTAuditFile">
<xsd:complexType>
<xsd:sequence>
<!--Tables-->
<xsd:element name="Companies" type="CompanyInformation"/>
<xsd:element name="Purchases" type="PurchaseListing"/>
<xsd:element name="Supplies" type="SupplyListing"/>
<xsd:element name="Ledger" type="GeneralLedger"/>
<xsd:element name="Footer" type="Footer"/>

</xsd:sequence>
</xsd:complexType>
</xsd:element>
<!--COMPANY INFORMATION-->
<xsd:complexType name="CompanyInformation">
<xsd:sequence>
<xsd:element name="Company" minOccurs="1" maxOccurs=”1" >
<xsd:complexType>
<xsd:sequence>
<xsd:element name="BusinessName" type="xsd:string"/>
<xsd:element name="BusinessRN" type="xsd:string"/>
<xsd:element name="GSTNumber" type="xsd:string"/>
<xsd:element name="PeriodStart" type="xsd:date" default="9999-12-31"/>
<xsd:element name="PeriodEnd" type="xsd:date" default="9999-12-31"/>
<xsd:element name="GAFCreationDate" type="xsd:date" default="9999-12-31"/>
<xsd:element name="ProductVersion" type="xsd:string"/>
<xsd:element name="GAFVersion" type="xsd:string" default="GAFv1.0.0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>

XML Sample (Output)

<?xml version="1.0" encoding="utf-8"?>
<GSTAuditFile>
<Companies>
<Company>
<BusinessName>ABC SDN BHD</BusinessName>
<BusinessRN>654321-V</BusinessRN>
<GSTNumber>IDGST:10001/2015</GSTNumber>
<PeriodStart>2015-12-01</PeriodStart>
<PeriodEnd>2015-12-31</PeriodEnd>
<GAFCreationDate>2015-12-31</GAFCreationDate>
<ProductVersion>2015-12-31</ProductVersion>
<GAFVersion>2015-12-31</GAFVersion>
</Company>
</Companies>
<Purchases>
<Purchase>
<SupplierName>MEI MEI SDN BHD</SupplierName>
<SupplierBRN>123456-G</SupplierBRN>
<InvoiceDate>2015-12-19</InvoiceDate>
<InvoiceNumber>STV/012324/8</InvoiceNumber>
<ImportDeclarationNo />
<LineNumber>1</LineNumber>
<ProductDescription>Purchase of shark fins</ProductDescription>
<PurchaseValueMYR>300</PurchaseValueMYR>
<GSTValueMYR>18</GSTValueMYR>
<TaxCode>TX</TaxCode>
<FCYCode>XXX</FCYCode>
<PurchaseFCY>0</PurchaseFCY>
<GSTFCY>0</GSTFCY>
</Purchase>
<Purchase>
<SupplierName>THAI FISH CRACKERS</SupplierName>
<SupplierBRN />
<InvoiceDate>2015-12-17</InvoiceDate>
<InvoiceNumber>SH7997561</InvoiceNumber>
<ImportDeclarationNo>B11124699</ImportDeclarationNo>
<LineNumber>1</LineNumber>
<ProductDescription>Purchase of fish crackers from Thai</ProductDescription>
<PurchaseValueMYR>1700</PurchaseValueMYR>
<GSTValueMYR>102</GSTValueMYR>
<TaxCode>IM</TaxCode>
<FCYCode>USD</FCYCode>
<PurchaseFCY>485.71</PurchaseFCY>
<GSTFCY>29.14</GSTFCY>
</Purchase>
<Purchase>

Hi, have you found the solution?

JC
on 6/12/14, 1:08 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

3 follower(s)

Stats

Asked: 5/31/14, 4:18 AM
Seen: 1612 times
Last updated: 3/16/15, 8:10 AM