How to Configure Sage300 2018 so that store Date and time for OEOrder and OEInvoice

Hi Expert ,

    I am using Sage300 api . I want to filter  api with Order /Invoice Creation datetime . I am facing one issue in my response i can't see any time in creation datetime field .

Any one can help me how it can be possible that Date and Time both will be saved for Order / Shipment and Invoice.

Thanks

Surajit Kundu

  • <OrderDate>2020-06-30T00:00:00Z</OrderDate>
    <ExpectedShipDate>2020-06-30T00:00:00Z</ExpectedShipDate>
    <QuoteExpirationDate />
    <OrderFiscalYear>2019</OrderFiscalYear>
    <OrderFiscalPeriod>Num1</OrderFiscalPeriod>
    <ShipViaCode>CCT</ShipViaCode>
    <ShipViaCodeDescription>Cross-Country Trucking Lines</ShipViaCodeDescription>
    <LastInvoiceNumber>IN0000000000060</LastInvoiceNumber>
    <NumberOfInvoices>0</NumberOfInvoices>
    <FreeOnBoardPoint>Port of Vancouver, BC</FreeOnBoardPoint>
    <TemplateCode>ACTIVE</TemplateCode>
    <DefaultLocationCode>2</DefaultLocationCode>
    <OnHold>false</OnHold>
    <OrderDescription>Ship within 2 days</OrderDescription>
    <OrderComment></OrderComment>
    <OrderPrintStatus>None</OrderPrintStatus>
    <LastPostingDate>2020-06-30T00:00:00Z</LastPostingDate>
    <OrderNumberOfPrepayments>0</OrderNumberOfPrepayments>
    <OverCreditLimit>false</OverCreditLimit>
    <ApprovedLimit>-565.63</ApprovedLimit>
    <AuthorizingUserID></AuthorizingUserID>
    <RequiresShippingLabels>false</RequiresShippingLabels>
    <ShippingLabelsPrinted>false</ShippingLabelsPrinted>
    <OrderHomeCurrency>CAD</OrderHomeCurrency>
    <OrderRateType>SP</OrderRateType>
    <OrderSourceCurrency>USD</OrderSourceCurrency>
    <OrderRateDate>2020-03-18T00:00:00Z</OrderRateDate>