I am looking for an example to upload a journal entry directly from within Excel to Exact Online. For example, such as the entries in the Excel attached.
Is anything available?
I am looking for an example to upload a journal entry directly from within Excel to Exact Online. For example, such as the entries in the Excel attached.
Is anything available?
For posteringer er der forskellige muligheder.
Der findes en færdigpakket løsning på Get My Report. Vælg i menuen: Upload boekingen. Dokumentationen er tilgængelig på how to upload journal entries
Koden, der bruges af denne Get My Report-funktion, kan også bruges som inspiration og kører på enhver Invantive SQL-platform. Den er vedhæftet som gmr-eol-upload-excel-sheet-transaction-line-entries.sql. Den væsentlige del er:
create or replace table xmlupload@inmemorystorage
as
select 'GLTransactions' topic
, division_code
, null orig_system_reference
, :orig_system_group orig_system_group
, xmlformat
( '<?xml version="1.0" encoding="utf-8"?>'
|| '<eExact xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="eExact-XML.xsd">'
|| xmlcomment('For division ' || division_code)
|| xmlcomment('Original system group ' || :orig_system_group)
|| '<GLTransactions>'
|| xml
|| '</GLTransactions>'
|| '</eExact>'
)
filecontents
from ( select division_code
, listagg
( head
|| lines
|| '</GLTransaction>'
, ''
)
xml
from ( select brl.division_code
, brl.head
, listagg(brl.line, '') lines
from sourcelinesxml@inmemorystorage brl
group
by brl.head
, brl.division_code
)
group
by division_code
)
;
--
-- Upload til Exact Online.
--
insert into UploadXMLTopics@eol
( topic
, payload
, division_code
, orig_system_reference
, orig_system_group
, fragment_payload_flag
, fragment_max_size_characters
, fail_on_error
)
select topic
, filecontents
, to_char(division_code)
, orig_system_reference
, orig_system_group
--
-- Forsøg at opdele i stykker på højst 25 KB.
--
, true fragment_payload_flag
, 25000 fragment_max_size_characters
--
-- Returnerer fejl gennem brugergrænsefladen, ikke som en HTTP 500-fejl.
--
, false fail_on_error
from xmlupload@inmemorystorage
order
by division_code
, orig_system_reference
, orig_system_group
Koden er noget kompleks for at sikre, at den kan håndtere upload af 100K+ posteringslinjer pr. division uden forstyrrelser.
Du kan også uploade posteringer på to måder fra Invantive Control for Excel:
Udfør følgende trin:
En mere omfattende forklaring på upload af posteringslinjer baseret på dit oprindelige regneark findes i videnbasen.
This question was automatically closed after at least 2 weeks of inactivity after a possible solution was provided. The last answer given has been marked as a solution.
Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.